will said:
How do you do a lookup with multiple values
Your question could have been clearer!
If you want to do a two-dimensional lookup, this formula looks up A1(row)
and B1 (column) in an array named 'Table':
=INDEX(Table,MATCH(A1,INDEX(Table,,1),0),MATCH(B1,INDEX(Table,1,),0))
If you want to do a double-column lookup, this formula looks up D1 in column
A and E1 in column B, returning the column C value corresponding to the
first double match:
=INDEX($C$1:$C$10,MATCH(1,($A$1:$A$10=D1)*($B$1:$B$10=E1),0))
Note that this is an array formula, so has to be entered using
CTRL+SHIFT+ENTER rather than just ENTER.
