VLOOKUP - Multi Condition

  • Thread starter Thread starter Lookup Help
  • Start date Start date
L

Lookup Help

I've tried to use the match case to return a value based
on two conditions but it doesn't seem to work. Does
anyone know of a way to use VLOOKUP with multiple
conditions?

This is the formula I used with Match:
=INDEX(C2:C10,MATCH(1,(A2:A10=3)*(B2:B10=15),0))

This was entered as an array formula.

Thanks in advance!
 
You formula is correct array entered,
maybe the numbers are text, try

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

or better convert them to numbers

copy an empty cell, select A2:B10, do edit>paste special, select add
 
I only get N/A as the return value.
-----Original Message-----
You formula is correct array entered,
maybe the numbers are text, try

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

or better convert them to numbers

copy an empty cell, select A2:B10, do edit>paste special, select add




--

Regards,

Peo Sjoblom





.
Click to expand...
 
That means the condition is not true and if you are sure it is true then you
have
either text numbers or text numbers with hidden characters (char 160 for
example)
Did you try to convert them using the paste special method?
 
Back
Top