Posted to microsoft.public.excel.misc

Paul

external usenet poster

Posts: 661

Lookup on Multiple Criteria

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.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Lookup by multiple criteria.	MFM	Excel Worksheet Functions	5	November 14th 08 10:20 PM
Multiple lookup criteria	Cam1234	Excel Discussion (Misc queries)	3	November 4th 08 10:26 PM
Lookup using multiple sheets and multiple criteria, sorry if 2 pos	kjguillermo	Excel Worksheet Functions	4	January 16th 07 03:21 AM
Lookup using multiple sheets and multiple criteria	kjguillermo	Excel Discussion (Misc queries)	2	January 14th 07 10:28 AM
Lookup with Multiple Criteria	cbanks	Excel Discussion (Misc queries)	1	January 26th 06 07:31 PM

All times are GMT +1. The time now is 03:50 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us