View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dean Hinson[_3_] Dean Hinson[_3_] is offline
external usenet poster
 
Posts: 35
Default 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.