Lookup on Multiple Criteria
Mike,
I put this in, and I have no idea of how it works but it does. I consider
myself to be a pretty strong user, but I have no idea of how this works.
Would it be too much to ask for a narrative of what this is doing?
"Mike H" wrote:
Hi,
You didn't tell us where name is is this assumes column D. Try this
=INDEX($D$2:$D$12,MATCH(1,INDEX(($A$2:$A$12=K1)*($ B$2:$B$12=L1)*($C$2:$C$12=M1),),),)
Where K1, L1 & M1 are the values you are lookung for in Columns A, B, & C
Mike
"Paul" wrote:
I have the following situation:
I have a sheet that I need to lookup "Name" when "Col A" = value 1 AND "Col
B" = value 2, and "Col 3" = value 3. There is only one unique solution.
Basically I need a Vlookup with an "AND" function. The value that I am
looking for a text field, or else I would try a pivot table.
Help.
|