Help using the Lookup Function

[shadestreet]

I need to search for a value based on two different criterias.

I have only used VLookup or HLookup for 1 criteria, and would like t
know how to use a combination of the two. I am sure there are multipl
approaches, but I wanted to know the simplest method.

In Cell A1 there is a Validation list consisting of 5 choices. In Cel
B1 there is a second Validation list of consisting of the same
choices. In a separate sheet I have a Matix consisting of all 2
combinations (the choices for A1 run horizontal, the choices for B1 ru
Vertical). Depending on what choices are input to A1 and B1, I need t
return the value in the cell that corresponds to this combination.

I could go into more detail if necessary (or if no one responds).\

Thank

 

[Frank Kabel]

Hi
try something like the following:
=INDEX('lookup'!$A$1:$F$6,MATCH(A1,'lookup'!$A$1:$A$6,0),MATCH(B1,'look
up'!$A$1:$F$1,0))