Posted to microsoft.public.excel.programming

Dean Hinson[_3_] Dean Hinson[_3_] is offline

external usenet poster

Posts: 35

Search An Array in VBA

Hello,

I have a multidimensional array that is sorted on the first column and was
trying to use the VLOOKUP to search for particular entries. VLOOKUP doesn't
seem to reconize arrays. Has anybody been able to incorporate a faster
search other than scanning the array by looping through iterative times?

Any help is appreciated.

Dean.

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
array search	Luke	Excel Worksheet Functions	8	February 2nd 09 08:25 AM
Search for reference in an array	DoubleZ	Excel Discussion (Misc queries)	4	November 7th 08 10:55 PM
search array	jchick0909	Excel Worksheet Functions	3	October 5th 07 07:25 PM
SEARCH EXCEL ARRAY FOR NON-VOIDS AND ENTER INTO ANOTHER ARRAY,	ROSE THE RED	Excel Programming	1	December 31st 04 06:01 PM
Search an array	[email protected]	Excel Programming	3	October 21st 03 08:47 PM

All times are GMT +1. The time now is 02:53 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us