find number from co-ordinates
 

Hi

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

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

any help is appreciated
Thanks

find number from co-ordinates
 

=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)


On Apr 11, 8:18 am, shnim1 wrote:
Hi

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

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

any help is appreciated
Thanks

--
shnim1

This should help.