Hi all,

No one could help me with this before so I will repost hoping it'll be
different this time. I need to lookup a value in a worksheet of data
based on 4 different criteria. I can use Vlookup for looking up data
based on 1 criteria, and I can use SUMPRODUCT to look up values based
on multiple criteria, but I need to lookup a text entry based on 4
criteria. For example, in a worksheet in Excel I have 10 columns of
data. I would like to know the name of the person who lives in the
state of New York, was born in 1980, is a male, and drives an
Oldmobile. This is really done for illustration purposes and is not
exactly what I'm looking for, but just an example of it. Can someone
please help?

Thanks!