Array Match Formula

[jim.excel]

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

 

[Biff]

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