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

vlookup

ResolvedVersion 2003

Farah has attended:
Excel Introduction course
Excel Intermediate course
Excel Advanced course

Vlookup

how do i use vlookup?

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.

 

Training courses

Training information:

See also:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.

Excel tip:

Selecting constant values only

If periodically you need to change all your values back to zero, but leave formulas, text and blank cells as they are select the entire worksheet, choose F5 function key, Special and then Constants and choose the appropriate sub-selections. To enter zero in all the selected cells type 0 and then press Ctrl+Enter.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.11 secs.