View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
RidgeView RidgeView is offline
external usenet poster
 
Posts: 21
Default In VBA Excel 2007, is there a substitution for VLookup?

I did not realize that VLookup is not a viable function in Excel 2007 VBA.
Is there a substitute instruction? Currently I am doing a FOR/NEXT routine.
Thanks in Advance....