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 » Vlookup

Vlookup

resolvedResolved · Low Priority · Version 2003

Susan has attended:
Excel Intermediate course
Excel Advanced course

Vlookup

How do I use the Vlookup function?

RE: vlookup

Hello Susan

Thank you for your question and welcome to the forum.

The VLOOKUP function is used to extract a certain piece of data from a list.

The function asks Excel to look for a particular item (the lookup value) through the leftmost column of a table, and then extract a piece of information in the same row, from a different column.

The function syntax is as follows:
=VLOOKUP(lookup value,table array,column index number,range)

The lookup value is the item you are getting Excel to look for in the leftmost column of the table array.

The column index number is the number of the column that you want Excel to extract the corresponding piece of data from. Each column in the table array is allocated a number, starting from 1 being allocated to the leftmost column and each of the following columns being numbered consecutively.

The range refers to if you need an exact or approximate match to the lookup value you specify. If you require an exact match enter false; if you require an approximate match ('near enough is good enough'), enter true or leave the range part of the function blank.

I hope this helps.
Amanda

RE: vlookup

Hi Susan,

You can find here some good tutorials with animated videos for using the vlookup function:
vlookup

 

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:

Removing the Ribbon from view in Excel 2010

At times when you want to view the whole spreadsheet, try double clicking on the ''Home'' tab on the ribbon which will hide the ribbon from view.

View all Excel hints and tips


Server loaded in 0.08 secs.