View Single Post
  #1   Report Post  
shnim1 shnim1 is offline
Junior Member
 
Posts: 23
Default 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