Home |
Search |
Today's Posts |
#1
|
|||
|
|||
two criteria in a vlookup
how would i do a lookup to return a value if two conditions are met.
instead of =vlookup(a1,d1:h80,2,0) i would like a value to return if a1 and b1 are matched? thank you c |
#2
|
|||
|
|||
Hi!
This all depends on how your lookup table is setup. Need more detail. Biff -----Original Message----- how would i do a lookup to return a value if two conditions are met. instead of =vlookup(a1,d1:h80,2,0) i would like a value to return if a1 and b1 are matched? thank you c . |
#3
|
|||
|
|||
It's not clear what you mean, do you want to lookup A1 and B1 in one column
of the lookup table? If so use =VLOOKUP(A1&B1,D1:H80,2,0) if not post back Regards, Peo Sjoblom "CMAC" wrote: how would i do a lookup to return a value if two conditions are met. instead of =vlookup(a1,d1:h80,2,0) i would like a value to return if a1 and b1 are matched? thank you c |
#4
|
|||
|
|||
I'm too am looking to return a value when 2 criterias are met, not a
combined set of words to make one. I want to look up a1 and then b1 in a table where it will return xx. columnA columnB value_to_return Marketing Director John Doe lookupA lookupB value_to_return Marketing Director John Doe Marketing Manager Joe Doe -- Message posted via http://www.officekb.com |
#5
|
|||
|
|||
Hi!
Assume your lookup table is in the range A5:C6. A1 and B1 are the lookup values. In C1 enter this array formula with the key combo of CTRL,SHIFT,ENTER: =INDEX(C5:C6,MATCH(1,(A5:A6=A1)*(B5:B6=B1),0)) If no match is found #N/A will be returned. To keep #N/A from being displayed enter this formula, also an array: =IF(ISERROR(MATCH(1,(A5:A6=A1)*(B5:B6=B1),0)),"",I NDEX (C5:C6,MATCH(1,(A5:A6=A1)*(B5:B6=B1),0))) Biff -----Original Message----- I'm too am looking to return a value when 2 criterias are met, not a combined set of words to make one. I want to look up a1 and then b1 in a table where it will return xx. columnA columnB value_to_return Marketing Director John Doe lookupA lookupB value_to_return Marketing Director John Doe Marketing Manager Joe Doe -- Message posted via http://www.officekb.com . |
#6
|
|||
|
|||
Thanks, Biff. That's great! You have been very helpful.
-cy -- Message posted via http://www.officekb.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUMPRODUCT Formula to Count Row of data Below Matched Criteria | Excel Worksheet Functions | |||
vlookup data hidden within worksheet | Excel Worksheet Functions | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions | |||
VlookUp with Multiple Criteria? | Excel Worksheet Functions | |||
Multiple Vlookup? | Excel Worksheet Functions |