The Lookup Value
The first argument is the Lookup_value. It tells VLOOKUP about which item in the database we are seeking information. The Lookup_value is located in the first column of the selected range.
The information that VLOOKUP will return is always from the same row of the database as the Lookup_value.
The Lookup_value can be a text string, a logical value (TRUE or FALSE only), a number, or a cell reference to a value.
Tutorial Steps
- Click on the Lookup_value line in the dialog box
- Click on cell D2 in the worksheet to add this cell reference to the Lookup_value line. This is the cell where we will type the part name about which we are seeking information.
