VLOOKUP

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

Resolved · Low Priority · Version 2003

1 post

ReplyThu 4 Feb 2010, 16:20Delegate Jean said...

Jean has attended:
Excel Advanced course

VLOOKUP

Please could you go over how to create/use look up again!

Version	Date	Location	Places available	Book	Next place rate (£)
Excel Intermediate 1 day course
Version	Date	Location	Places available	Book	Pay by Card	Pay by Invoice
2007	Thu 18 Mar 2010	Bloomsbury	1		£224	£225
2003	Thu 18 Mar 2010	Limehouse	0	FULL
2007	Mon 22 Mar 2010	Limehouse	3		£224	£225
2003	Tue 23 Mar 2010	Southwark	6		£199	£204
2007	Thu 25 Mar 2010	Rochester (Hoo)	0	FULL
2003	Fri 26 Mar 2010	Limehouse	4		£224	£225
Full Schedule: See all 79 Excel Intermediate course dates. Bookings currently available until 23rd December 2010.

1,055 posts

ReplyWed 10 Feb 2010, 13:42Trainer Andrew said...

RE: VLOOKUP

Hi Jean

Thank you for your question. The basic VLOOKUP function is structured as follows:

VLOOKUP(Lookup Value, Table array, Column index number, Range lookup)

The components are:

Lookup Value
This is the input cell or value that Excel will look for in the first column of your selected table of data.

Table array
This is the block of cells that contains the data to be search and the values to be returned after Excel has found the Lookup Value. The first column of the block is the key field. Excel will look for a record that matches the Lookup Value in the first column.

Column index number
This is the number of the column that contains the value Excel should return when it finds a record matching the Lookup Value. Numbering starts from the first column of the table array (not necessarily the first column of your worksheet).

Range lookup
Set to either True (find approximate match or FALSE find exact match. If you know one record will match your Lookup value then set to False. If omitted VLOOKUP assumes TRUE.

I hope this helps describe the way a vlookup works. Let me know if you have any further questions.

Kind regards,
Andrew

Wed 17 Feb 2010: Automatically marked as resolved.

· Let Excel look after the pennies, and the pounds will take care of themselves
· Compare Different MS Excel Training Methods
· Preparing to Pivot: Why all Excel users should know about Pivot Tables
· Using Excel In Any Condition
· So Can You Really Sort On Colours In Excel 2007?

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

Excel tip:

Freeze Rows and Columns to keep lables displayed

You can freeze rows and columns in your worksheet so they don't move.

This allows you to keep row and column labels displayed on your screen as you move through a large worksheet.

Click below and/or to the right of the cell(s) you want to freeze. (NB. Excel freezes ALL the rows above and ALL the columns to left of the selected cell)

Click on the 'Windows' menu and selct 'Freeze Panes'.

Lines appear in your worksheet. The required rows and columns are frozen and remain on your screen as you move through your worksheet.

To unfreeze rows and columns, click on 'Window' menu and select 'Unfreeze Panes'.

View all Excel hints and tips