How to create a Vlookup function in Excel


There are many types of lookup functions in Microsoft Excel, there is Lookup, Vlookup, Hlookup, Choose, Match and Index. The Vlookup is the simplest and therefore the most popular. The V in Vlookup stands for Vertical lookup. The H in Hlookup stands for horizontal lookup. Most times if your lookup value is presented horizontally you may have decided to select the data and perform a Copy/Paste Special Transpose then go ahead and do your Vlookup Function. If you only knew, you could have simply used the Hlookup function in Microsoft Excel.

When creating a vlookup remember it will only look to the right. If you need it to look to the Left and the right of the Lookup Value use the index function with the match function together.

There are a few things to check before you can go crazy and start typing your Vlookup function. The table must be SORTED by the FIRST column in your Master List or table. Make sure you know the column number before you start typing your function. The structure for the Vlookup is as follows.

=Vlookup(Lookup value,Table,Col Number, False)

You can replace the table data with a Range Name, this will help to understand what the Vlookup is doing.

False or 0 means: Exact match to Lookup value

True or 1 Means: Nearest Lowest match to Lookup value (True is the default)

If you need to find the nearest highest, then the Vlookup is not the right tool for you. Try a different function like Index and Match together.

If you are still struggling AZ Solutions Pty Ltd provides Customized Face to Face training in Sydney – Australia.

Advertisements

About Customised Computer Courses Sydney - Sutherland Shire M 0414 417 059

On-Site customised computer training courses Sydney - Sutherland Shire. Excel, Word,Power Point, Access, Outlook, Visio, Publisher, Excel VBA e: Info@azsolutions.com.au m: 0414 417 059 www.azsolutions.com.au
This entry was posted in Excel and tagged , , , , , . Bookmark the permalink.

3 Responses to How to create a Vlookup function in Excel

  1. Pingback: Vlookup not working? | SYDNEY Computer Training Courses

  2. Pingback: Naming cells in Microsoft Excel | SYDNEY Computer Training Courses

  3. Pingback: Modifying a Range Name in Microsoft Excel – AZ Solutions

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s