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
|