Posted to microsoft.public.excel.misc

FARAZ QURESHI FARAZ QURESHI is offline

external usenet poster

Posts: 553

VLOOKUP 4 MULTIPLE ARRAYS?

Any idea how to devise a formula as VLOOKUP to lookup into multiple arrays?
Suppose, I want to skip rows 11:11, 15:15, 20:20 and 30:32 from the range
A1:C50 for looking up a value only in the remaining records?

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
Arrays - Nested IF with Vlookup?	RV	Excel Discussion (Misc queries)	3	September 25th 07 09:09 PM
LOOKUP across multiple arrays	willcozz	Excel Discussion (Misc queries)	0	December 15th 06 04:36 PM
sum of multiple arrays?	paula k	Excel Worksheet Functions	3	August 17th 06 08:35 PM
Multiple Arrays, Vlookup	Oggie Ben Doggie	Excel Worksheet Functions	2	June 26th 06 10:29 PM
Using Vlookup in formula arrays	BartDesc	Excel Worksheet Functions	4	July 3rd 05 04:42 PM

All times are GMT +1. The time now is 12:09 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us