Vlookup

Resolved · Low Priority · Version 2003

Vlookup

Kate has attended:
Excel VBA course

by - delegate Kate [2 posts] (2008 Aug 15 Fri, 16:46) Reply

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

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Dec 11 Thu + 12 Fri	Bayswater	3	book now	£525	£545
2007	2009 Jan 8 Thu + 9 Fri	Bloomsbury	7	book now	£450	£475
2003	2009 Jan 22 Thu + 23 Fri	Southwark	4	book now	£475	£485
2003	2009 Jan 29 Thu + 30 Fri	Bayswater	5	book now	£450	£485
2007	2009 Feb 5 Thu + 6 Fri	Bloomsbury	7	book now	£450	£475
2003	2009 Feb 19 Thu + 20 Fri	Southwark	8	book now	£275	£399
Full Schedule: See all 33 Excel VBA course dates. Bookings currently available until 26th November 2009.

RE: Vlookup

by - trainer Carlos gold contributer [479 posts] (2008 Sep 4 Thu, 10:48) Edited on 2008 Sep 4 Thu, 10:50 Reply

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

· Advanced level training: Microsoft Excel and the Web
· How Excel Training Can Improve Your Company's Sales Process
· Excel Course Tips and Tricks to Liven Up Your Excel Spreadsheets
· Microsoft Excel Training - Discover A Hidden Power At Your Fingertips
· Tips for Transitioning to Excel 2007

Please browse our web site to find out more about
microsoft excel courses in and other Microsoft training courses.

Excel tip:

Shortcut keys to move between sheets

Instead of clicking on a sheet tab to view a sheet, use the following keyboard shortcuts to move between sheets in the same file:

Ctrl + Page Down - Switch to the next worksheet (to the right)

Ctrl + Page Up - Switch to the previous worksheet (to the left)

View all Excel hints and tips

Rate this page: