Posted to microsoft.public.excel.misc

EoinL

external usenet poster

Posts: 1

Vlookup with more than 1 criteria

Dog brown 25
Dog Grey 28
Cat Blue 30
Rabbit Brown 12
Dog grey 18

Can the vlookup function be used to lookup more than one value in a row and
return a single corresponding value?

In the example below I want to return the value 25. But if I lookup "dog",
there's two and if I look up "brown" there's also two so I need to lookup dog
and brown together?

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
VLOOKUP or IF with many criteria	Alys	Excel Worksheet Functions	2	April 17th 07 01:26 PM
vlookup with two criteria	hollister22nh	Excel Worksheet Functions	1	February 25th 06 02:42 PM
vlookup with two criteria	hollister22nh	Excel Worksheet Functions	2	February 25th 06 11:42 AM
VLOOKUP with MAX criteria	tralls	Excel Discussion (Misc queries)	2	October 26th 05 12:12 AM
vlookup with two criteria	BJ	Excel Worksheet Functions	2	March 29th 05 10:37 PM

All times are GMT +1. The time now is 01:33 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us