Lookup in a list

D

dveenhuis

I am familiar with the simple lookup function, find a value and return
value in next column, etc. My question is can I lookup and a valu
based on the value in TWO adjacent cells
 
P

Peo Sjoblom

Here is one way

=INDEX(C2:C10,MATCH(1,(A2:A10="b")*(B2:B10=3),0))

lookup "b" in A2:A10 where B2:B10 is 3 and retrun the value from C2:C10

Needs to be entere with ctrl + shift & enter

Regards,

Peo Sjoblom
 
Top