Kate has attended:
Excel VBA Intro Intermediate course
Vlookup
How to do you use Vlookup in macros..??
RE: Vlookup
Hi Kate
Sorry for the delay in answering this question.
To use the VLOOKUP function in a macro you need to call up the macro with the following code:
Dim Answer As [Type] (Select the type to correspond to the type of value being returned)
Answer = Application.WorksheetFunction.VLookup(Arg1, Arg2, Arg3, [Arg4])
The arguments are the same as when running the VLOOKUP function in the worksheet
The WorksheetFunction command allows you to access all the functions found in Excel's Insert Function dialog box
Hope this helps
Carlos