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