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

ReplyWed 13 May 2009, 13:59Delegate Farah said...

Vlookup

how do i use vlookup?

For upcoming training course dates see: Pricing & availability

ReplyWed 13 May 2009, 15:10Trainer Amanda said...

RE: vlookup

Hello Farah

Thank you for your question.

Vlookup is used to be able to extract and display a piece of data from a single cell in a table of Excel data.

It works by looking for a unique piece of data (lookup value) in the left most column of your table, then pulls out a piece of data from the same row, from the column that you specify.

I hope this helps.

Kind regards
Amanda

Wed 20 May 2009: Automatically marked as resolved.

Excel articles

· So Can You Really Sort On Colours In Excel 2007?
· That's The Wonder Of Autofill
· What Makes A Good Spreadsheet?
· Conditional Formatting in Excel 2007
· How To Use Functions In Excel 2010

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

Excel tip:

Hiding Formulae in the Formula Bar

It is possible to protect the contents of a cell reference(s) from amendment by applying cell protection. The contents of the cell reference can also be stopped from displaying in the formula bar.

Step 1: Select Format > Cells > Protection.

Step 2: Tick Hidden option. Ensure Locked is ticked

Step 3: Select Tools > Protection > Protect Sheet

(Ensure "Protect worksheet and contents of locked cells" is ticked)

View all Excel hints and tips

Hello
Can we edit the standard styles of bullets and numbering?
i.e. we would like to disable some of the ones which Word offers.
We know we can add list styles, but we would also like to remove some which we don't want to see in our documents.
Hop..

» Forum post: Bullets and numbering

Rate this page:

Currently 2.15/5
1
2
3
4
5

2.2/5 (213 votes cast)

Add to:

Follow @beststl on Twitter

© 2012 Best STL. All Rights Reserved. A Microsoft software training company. info
All prices offered for business users and exclude VAT. E&OE · Terms and Conditions