The Lookup Value Argument
Normally, the lookup value matches a field of data in the first column of the data table.
In our example, the lookup value refers to the type of cookie we want to find information about.
The allowable types of data for the lookup value are:
- text data
- a logical value (TRUE or FALSE only)
- a number
- a cell reference to a value in the worksheet
In this example we will enter the cell reference to where the cookie name will be located - cell D2.
Tutorial Steps
- 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 cookie name about which we are seeking information
