Excel 2016 Data and List Management

Lesson 1 – Using Advanced Functions

Excel 2016

3. Select the cell containing the value you want to look up. 4. Type a comma ( , ). 5. Type the name or address of the lookup table. 6. Type a comma ( , ).

7. Enter the row index number. 8. Type a closing parenthesis ( ) ). 9. Press [Enter] .



S TEP - BY -S TEP

Use the HLOOKUP function.

If necessary, display the Orders worksheet.

Select shipping from the Name Box (the list box to the left of the formula bar) to view the lookup table.

Steps

Practice Data

1. Select the cell in which you want the result of the HLOOKUP

Click cell F5

function to appear. The cell is selected.

2. Type =hlookup and an open parenthesis ( ( ). =hlookup( appears in the cell and on the formula bar. As you start typing a function, a Screen Tip is displayed to help you enter valid arguments. 3. Select the cell containing the value you want to look up. A blinking marquee appears around the cell and its address

Type =hlookup(

Click cell E5

appears in the HLOOKUP function.

4. Type a comma ( , ).

Type ,

The comma ( , ) appears in the HLOOKUP function.

5. Type the name or address of the lookup table. The text appears in the HLOOKUP function.

Type shipping

Page 8

OFFICEPRO, Inc.