Retrieving Data with the Finished HLOOKUP Function
To do so, type the name of the item you wish to retrieve into the Lookup_value cell and press the ENTER key on the keyboard.
HLOOKUP uses the Row Index Number to determine which item of data should be shown in cell E2.
For this tutorial
Note: For help with these instructions, see the image above.
- Click on cell E1 in your spreadsheet.
- Type Bolt into cell E1 and press the ENTER key on the keyboard.
- The price of a bolt - $1.54 - should be displayed in cell E2.
- Test the HLOOKUP function further by typing other parts names into cell E1 and comparing the data returned in cell E2 with the prices listed in cells E5 to I5.