Using the Excel VLOOKUP Function
Related article: Excel 2007 VLOOKUP Function.
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.
