Hi!
Take your pick:
=VLOOKUP(A7,A2:C3,MATCH(A8,A1:C1,0),0)
=INDEX(B2:C3,MATCH(A7,A2:A3,0),MATCH(A8,B1:C1,0))
Biff
-----Original Message-----
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
.
|