find number from co-ordinates

[shnim1]

Hi

I have a grid that is full of numbers. Each row is labelled A, B, C an
so on downwards. At the top of each column are labels i,ii,iii and so o
going across. I am having difficulty in getting my formula to extrac
the cell content that lies at the intersection of two given inpu
numbers.

If I type in B and iii, another cell will give the number from a
intersection.

any help is appreciated
Thank

 

[ilia]

=INDEX($B$4:$I$14,MATCH(C1,$A$4:$A$14,0),MATCH(D1,$B$3:$I$3,0))

Enter row letter in C1 and column numeral in D1.

$B$4:$I$14 is your table (not including the row/column labels), $A$4:$A
$14 are the rows (A, B, C etc) and $B$3:$I$3 are the columns (i, ii,
iii etc)