Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup with 3 or more conditions
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup with 3 or more conditions
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). LondonLion wrote: 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 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vlookup considering 2 conditions | Excel Worksheet Functions | |||
How do you do a VLookup with two conditions? | Excel Worksheet Functions | |||
Vlookup using 2 conditions | Excel Discussion (Misc queries) | |||
How:iserror vlookup & count no. times value shows with conditions | Excel Worksheet Functions | |||
Vlookup with multiple conditions | Excel Worksheet Functions |