Using the Excel VLOOKUP Function
Related Tutorials:
Excel VLOOKUP Step by Step Tutorial
Excel HLOOKUP 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.
