Hi Tony,

Try this formula modified from a Google search of INDEX MATCH.

=INDEX(B2:D4,MATCH(LEFT(H1,1),A2:A4,0),MATCH(RIGHT (H1,1),B1:D1,0))

Whe
B1:D1 = A B C
A2:A4 = X Y Z
B2:D4 = The numbers
H1 = YB returns 3, ZA returns 7, etc.

HTH
Regards,
Howard

"Tony" wrote in message
...
In a spreadsheet as exampled below how can I get Excel to look up a
particular reference and use that in a calculation?

e.g.
A B C
X 4 6 7
Y 2 3 6
Z 7 4 9

So if I had entered in one cell YB it would use the value at their
intersection (3 in this case) in further calculations?

Hope someone can help. Thanks.

Tony
--
Tony