Hi,

The scenario:

With the data in A1:C3...

A B C
1 North South
2 Oil 1 2
3 Gas 3 4


and the Values in A7 and A8...


7 Gas
8 South
9 4

....what formula do I need to return the value at the intersection (the
4 shown in A9 in this case) of the Gas and South entries (or any other
valid combination) in A7 and A8 from the A1:C3 table?

Thanks,
Jim