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

What does a VLOOKUP do?

ResolvedVersion 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:

Calculate age or service

The DATEDIF() function in Excel calculates the number of days, months, or years between two dates. So, this function makes it easy to calculate a person's age. To try this tip:

In a blank worksheet, type the birth date in cell A1, using slashes to separate day, month, and year.
In cell A2, type =DATEDIF(A1,TODAY(),"y") and press ENTER.

View all Excel hints and tips

What does a VLOOKUP do?

What does a VLOOKUP do?

RE: VLOOKUP

Excel articles

Excel tip:

Calculate age or service