View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Pierre Leclerc[_2_] Pierre Leclerc[_2_] is offline
external usenet poster
 
Posts: 2
Default Searching values in VBA

Hi

I use a lot of INDEX/MATCH in my workbooks and I am looking for an
equivalent to INDEX/MATH or VLOOKUP in VBA.

When I have large sets of data I create Variant Arrays and I would
need a way to VLOOKUP things in one array to bring values in the other
array.

Anyone?
Pierre Leclerc
http://www.excel-vba.com