Formula to Get cell value if cell reference is known

Hello:

Please refer to attached file.
I have number 5 (row 5) and F (Column F)in cell A5 and B5
I need formula in cell A1 which will give numeric number of cell F5
Example
if A5=5 and B5= F then A1 needs to be 26
if A5=6 and B5= G then A1 needs to be 89

Let me know if you have any questions.
Thanks.

Riz

Try this in A1:

=IFERROR(INDIRECT(B5&A5),"")

Hope this helps.

Pete

Hi Pete:

Thanks a lot, works

Riz