Using the Excel VLOOKUP Function
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.
- "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.