Posted to microsoft.public.excel.misc

shakey1181

Posts: n/a

LOOKUP Question [again!]

Apologies for another query, I have managed to get around the last one, so
thanks to all who helped.

I'm still struggling with the LOOKUP Function. I need to do a 'double'
vlookup so for example,

A1 = 01/01/06
B1 = 23
C1 = 250

how do i set the lookup so it returns C1 only if A1 and B1 are correct? I
have tried using two sets of vlookup at once, but without success.

Thanks again

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
Another way to lookup data	David Vollmer	Excel Worksheet Functions	1	September 23rd 05 05:16 AM
Lookup function help	marlea	Excel Worksheet Functions	4	August 30th 05 08:11 PM
Lookup Type Question	carl	Excel Worksheet Functions	1	March 8th 05 08:30 PM
Formula Question... LookUP	G	Excel Discussion (Misc queries)	4	March 7th 05 01:38 AM
Lookup function w/Text and Year	Josh O.	Excel Worksheet Functions	1	February 12th 05 11:27 PM

All times are GMT +1. The time now is 04:32 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us