vlookup

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » What does a VLOOKUP do?

What does a VLOOKUP do?

resolvedResolved · Low Priority · Version 2007

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

What does a VLOOKUP do?

What does a VLOOKUP do?

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


 

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


Server loaded in 0.09 secs.