vlook up

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Vlook up?

Vlook up?

resolvedResolved · Low Priority · Version 2003

Anna has attended:
Excel Intermediate course

Vlook up?

what's vlook up?

Edited on Fri 8 Aug 2008, 09:02

RE: vlook up?

Hi Anna,
Thank you for your post: in answer:
The VLOOKUP function is used to extract information from data that is stored in a series of columns. Excel uses a lookup value which you type into a particular cell in the worksheet - to search for the value you have typed.
The syntax for a VLOOKUP is as follows: : =vlookup(search cell, database, column) to extract information from a specific point where row and column meet dependant upon the information in the search cell. I hope that has helped, regards Pete


 

Excel tip:

Adding up time greater than 24 hours

When you add up time if it exceeds 24 hours i.e 27 hours appears as 03:00. Go to Format / Cells / Number / Custom. The format is hh:mm but if change it to [hh]:mm it will add up to the correct amount of hours.

View all Excel hints and tips


Server loaded in 0.1 secs.