1. Technology
You can opt-out at any time. Please refer to our privacy policy for contact information.

Excel VLOOKUP Step by Step Tutorial

By

1 of 3

Excel VLOOKUP Function Tutorial
Excel's VLOOKUP Function

Excel's VLOOKUP Function

© Ted French

Using the Excel VLOOKUP Function

Related Tutorials:
Excel VLOOKUP 2007 / 2010 Step by Step Tutorial
Excel HLOOKUP 2007 / 2010 Step by Step Tutorial

Excel's VLOOKUP function, which stands for vertical lookup, is used to find specific information that has been stored in a spreadsheet table.

IF you have an inventory list of parts or a large membership contact list, VLOOKUP can help you find data that matches specific criteria such as the price of a specific item or a person's phone number.

VLOOKUP Example

Note: Refer to the image above for more information on this example. The syntax of the VLOOKUP function is covered in detail on page two.

=VLOOKUP("Widget",D4:E9,2,False)

  • "Widget" - this VLOOKUP function is looking for the price of Widgets.

  • D4 : E9 - it is looking for this information in the data table located in cells D4 to E9.

  • 2- VLOOKUP is looking for the price in the second column of the table.

  • False - indicates that only an exact match to the lookup _value "Widget" will be accepted.

The VLOOKUP function returns the results of its search - $14.76 - in cell D1.

©2014 About.com. All rights reserved.