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
.