Vlookup with 3 or more conditions

L

LondonLion

I have read from previous messages that lookups can be done with 2
conditions. Can they be done with 3 or more eg return a value if 3
conditions are met?

Thanks
 
D

Dave Peterson

You can use this kind of syntax:

=index(othersheet!$c$1:$c$100,
match(1,(a2=othersheet!$a$1:$a$100)*(b2=othersheet!$b$1:$b$100),0))
(one cell)

This is an array formula. Hit ctrl-shift-enter instead of enter. If you do it
correctly, excel will wrap curly brackets {} around your formula. (don't type
them yourself.)

Adjust the range to match--but you can't use the whole column.

=====
Just keep adding more to that product (inside the =match() portion).
 
Top