Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

vlookup

ResolvedVersion 2003

Kate has attended:
Excel VBA Intro Intermediate course

Vlookup

How to do you use Vlookup in macros..??

Edited on Thu 4 Sep 2008, 10:50

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

 

Training courses

Training information:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.

Excel tip:

Reset Excel toolbars to default settings

If you find any of your toolbars in Excel have changed (i.e. they are missing or have extra buttons) then you can reset them to their defaults.

1. Go to Tools - Customise.
2. Select the Toolbars tab.
3. Select (highlight) the name of the toolbar you wish to reset, then click the Reset button on the right.
4. Close the dialogue box.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.