Lookup using 2 cells as the "X" and "Y" coordinates....
 

I am trying to make a formula that will look at two cells (K2 and L2) which
can have the following typed in them:
K2 can be "A, B, C, D, or E"
L2 can be "I, II, III, or IV"
I have an array with A-E on (J1:N1 of Sheet2) and I-IV on (I2:I5 of Sheet2)
Based of of what is typed in the cells I want to look it up in the array.
Please help.

Lookup using 2 cells as the "X" and "Y" coordinates....
 

=INDEX(Sheet2!J2:N5,MATCH(L2,Sheet2!I2:I5),MATCH(K 2,Sheet2!J1:N1))
--
David Biddulph

"kcsims" wrote in message
...
I am trying to make a formula that will look at two cells (K2 and L2) which
can have the following typed in them:
K2 can be "A, B, C, D, or E"
L2 can be "I, II, III, or IV"
I have an array with A-E on (J1:N1 of Sheet2) and I-IV on (I2:I5 of
Sheet2)
Based of of what is typed in the cells I want to look it up in the array.
Please help.