What does a VLOOKUP do?

Resolved · Low Priority · Version 2007

Tue 17 Jan 2012, 16:35 Delegate Kristiana said...

Kristiana has attended:
Excel Advanced course
Excel Advanced - For Power Users course

What does a VLOOKUP do?

Fri 20 Jan 2012, 11:15 Trainer Paul said...

RE: VLOOKUP

use VLOOKUP to look up a value you want to find in an Excel list or table. Using VLOOKUP is similar to looking up a person’s name in a telephone book to get a telephone number. VLOOKUP looks at a value in one column, and finds its corresponding value on the same row in another column.

have a look at this link for more detail;

http://office.microsoft.com/en-gb/excel-help/vlookup-function-HP010343011.aspx?CTT=1

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Excel tip:

Display Functions on Worksheets

Functions in Excel can be difficult to recall their format/syntax

For example, you want to use the =PMT function.

Enter =PMT, then select keystroke, CTRL+SHIFT+A.

This usful memory jog, will display the arguments of a function on a worksheet, allowing the user to proceed with the generation of the function

View all Excel hints and tips