Lookup on Multiple Criteria

P

Paul

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

V Lookup multiple entires 1
LOOKUP FORMULA - USING THRESHOLDS - HELP 4
Case Sensitive v-lookup needed 3
Counting unique values in multiple columns 4
Loop Through Text and Test for Scenarios Q 31
closet lookup 2
How to use AVERAGEIFS for a date range 0
Calculate the median value before a specified list 0

Top