excel consultancy - VLOOKUP

The UK's most regular instructor-led training courses.
Training information: excel consultancy · Excel courses · Microsoft Excel Training UK
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version Standard

VLOOKUP

Ajay has attended:
Excel Advanced course
Access Introduction course

by - delegate Ajay [2 posts] (2007 Feb 7 Wed, 09:48) Reply

HOW DO I USE VLOOKUP

Version	Date	Location	Places available	Book	Next place rate:
Excel Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2002/XP	2008 Aug 29 Fri	Tooting	0	FULL
2003	2008 Sep 2 Tue	Bloomsbury	3	book now	£210	£215
2003	2008 Sep 4 Thu	Bayswater	4	book now	£195	£205
2007	2008 Sep 4 Thu	Bloomsbury	0	FULL
2003	2008 Sep 9 Tue	Bloomsbury	4	book now	£207	£215
2002/XP	2008 Sep 9 Tue	Tooting	0	FULL
Full Schedule: See all 138 Excel Intermediate course dates. Bookings currently available until 25th November 2009.

RE: VLOOKUP

by - trainer Amanda platinum contributer [947 posts] (2007 Feb 7 Wed, 10:00) Reply

Hi Ajay

Thanks for posting to our forum.

Vlookups are covered as part of the course you are on today, so hopefully by lunch time today you will be able to answer your own question :)

If you have any further questions after your training day today, you now have 12 months free support through our forum.

Enjoy your training today
Amanda

· Microsoft Excel Features and Functions for Accountants
· How to Create Better Excel Spreadsheets: Part Two
· Tools From Advanced Excel Courses: Goal Seek and Solver
· Excel Macros for the Non-Programmer
· Database Tips from an Excel Training Course

Excel tip:

Deleting a range of cells using the autofill handle

Firstly, select the range of cells for which you would like to clear the contents. Then drag the autofill handle to the the top left corner of the selection whilst holding down the shift key. Your selected contents should then be deleted.

View all Excel hints and tips