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