Thread: In VBA Excel 2007, is there a substitution for VLookup?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Kevin B Kevin B is offline
external usenet poster
  
Posts: 1,316
Default In VBA Excel 2007, is there a substitution for VLookup?
Use the following, substituting the range the formula is assigned to and the
arguments with the cell references you're using:

Range("A1").Formula = Application.WorksheetFunction.VLookup(Arg1, Arg2,
Arg3, [Arg4])

--
Kevin Backmann


"RidgeView" wrote:

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....
Reply With QuoteReply With Quote