Adding Headings for the HLOOKUP Function
Before starting the HLOOKUP function it is usually a good idea to add headings to the worksheet to show what data is being retrieved by HLOOKUP. For this tutorial enter the following headings into the cells indicated. The HLOOKUP function and the data it retrieves from the database will be located in cells to the right of these headings.
-
D1 - Part Name
E1 - Price
Opening the HLOOKUP Dialog Box
Although it is possible to just type the HLOOKUP function into a cell in a worksheet, many people find it easier to use the function's dialog box.
For this tutorial:
- Click on cell E2 to make it the active cell. This is where we will start the HLOOKUP function.
- Click on the Formulas tab.
- Choose Lookup & Reference from the ribbon to open the function drop down list.
- Click on HLOOKUP in the list to bring up the function's dialog box.
The data that we enter into the four blank rows in the dialog box will form the arguments of the HLOOKUP function. These arguments tell the function what information we are after and where it should search to find it.
Return to the Index page