Posted to microsoft.public.excel.misc

SteveH

external usenet poster

Posts: 8

Multiple VLOOKUP

Hi

I am using the following statement to VLOOKUP a part from name range "look"

=IF(ISBLANK(A2),"",(VLOOKUP(A2,look,2,FALSE)))

I need to be able to lookup multiple ranges i.e. look2, look3

How do I modify the above statement to successfully look for "part A" in
look, look2 and look3?

Cheers

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
Multiple if and Vlookup	Anto111	Excel Discussion (Misc queries)	3	June 4th 08 05:32 PM
Vlookup with Multiple criteria and multiple sheets	Cinny	Excel Worksheet Functions	4	June 21st 07 01:47 AM
Vlookup for multiple criteria, multiple worksheets	jtoy	Excel Worksheet Functions	4	January 25th 07 09:26 PM
How do I use VLOOKUP to ref multiple workbooks with multiple tabs?	JackieW	Excel Discussion (Misc queries)	2	April 11th 06 05:32 PM
multiple vlookup	choice	Excel Worksheet Functions	2	November 1st 04 06:55 PM

All times are GMT +1. The time now is 08:53 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us