The Lookup Value Argument
The lookup value is located in the first column of the table of data. After specifying a subject in the first column, VLOOKUP will then allow you to search for specific information located in the same row as the subject.
The lookup value can be text, a logical value (TRUE or FALSE only), a number, or a cell reference to a value.
It is a good idea to use an absolute cell reference for the lookup value.
If you don’t use an absolute reference and you copy the VLOOKUP function to other cells, there is a good chance you will get error messages in the cells the function is copied to.
- Click on the lookup_value line in the dialog box
- Click on cell D2 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.
- Press the F4 key on the keyboard to make the cell reference absolute.