Vlookup

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

Resolved · Low Priority · Version Standard

Vlookup

Deirdre has attended:
Excel Advanced course

by - delegate Deirdre [1 post] (2008 Feb 22 Fri, 16:40) Reply

Apart from numbering columns incrementally in a specific row or counting the columns, is there any way to determine the column number when using 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 Rich platinum contributer [711 posts] (2008 Feb 23 Sat, 21:33) Reply

No - you will need to know the number of the column you want. You can get a list by highlighting the entire headings row and in a new tab right click in a cell. Choose Paste special and select transpose. This will give you a vertical list which might help you see what columns there are in a list format which you can then add numbers to.

· Identifying Suitable Candidates For VBA For Excel Training
· Do You Really Need Excel VBA Training?
· Prepare for your MOS Certification with MS Excel Courses
· Tap the Power of Recorded Macros with MS Excel Courses
· MS Excel: Excel At Making The Most Of Your Christmas

Please browse our web site to find out more about
excel computer course london and other Microsoft training courses.

Excel tip:

Remove unused toolbar buttons

Are there buttons on your Excel toolbars that you never use? Remove them from the toolbar by doing the following:

1. Go to Tools - Customise - Commands.
2. Select the toolbar button you wish to remove, then use your mouse to drag and drop the button into the Excel window. When you release your finger from the mouse, the button will disappear.

View all Excel hints and tips