Search An Array in VBA
Dean Hinson wrote:
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.
When you say "search for particular entries", do you mean search for
particular entries corresponding to a specified value in the first
"column" of the array? If so, Tom Ogilvy has posted a sample with
correct syntax. Otherwise you need to be a little more specific about
what you're trying to search for.
Alan Beban
|