VLOOKUP - Multi Condition

[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!

 

[Peo Sjoblom]

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

 

[Frank Kabel]

Hi
this formula should do. What wrong result did you get?

 

[Guest]

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





.

 

[Peo Sjoblom]

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?