The UK's Number 1 for Microsoft Office Training

Sitemap

Bookmark page

Printable version

Course updates
due to adverse
weather conditions

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » VLOOKUP

	98.3 % recommend us
	More live stats...

Bookmark this page

Share this with a friend or colleague:

The UK's most regular
instructor-led training courses.

Training information:

VLOOKUP

Resolved · Low Priority · Version 2003

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

VLOOKUP

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

For upcoming training course dates see: Pricing & availability

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.

Excel articles

· Spreadsheets: What's In A Name?
· Importing Excel Data Into Access
· Mastering Page Layout In Excel
· How To Create A Custom List In Excel
· Microsoft Excel can ensure you keep on top of your finances

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

Excel tip:

Generating Random Numbers

To generate a random number in Excel use the = RAND() function.

The value returned will always be between 0 and 1. To convert this to some other random value, you will need to multiply the result by the highest number you want to consider. For example, if you wanted a random number between 1 and 25, you could use the following code line:
= INT(25 * RAND()+ 1)

Since RAND() will always returns a value between 0 and 1 (but never 1 itself), multiplying what it returns by 25 and then using the Integer function INT on that result will return a whole number between 0 and 24.

Finally, 1 is added to this result, so that x will be equal to a number between 1 and 25, inclusive

View all Excel hints and tips

How Office 2010 Can Save The Day

Most of us are guilty of it; few will admit to it; and it doesn’t matter how often we promise ourselves never to do it again – it’s just a bad habit we can’t break. And what is this embarrassing practice none of us will own up to? Working on a document without saving, of course, and losing all of our data. But now, thanks to Microsoft Office 2010, help is at hand for closet Close phobics.

» Article: Sharepoint server courses

The best way to format text content in cells and also leave it good for using formulars and automisations?