Excel 2016 Tips and Tricks

Excel 2016

Lesson 3 – Using Advanced Functions

If necessary, display the Orders worksheet.

Select prices 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 VLOOKUP

Click cell C5

function to appear. The cell is selected.

2. Type =vlookup and an open parenthesis ( ( ). =vlookup( 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 =vlookup(

Click cell B5

appears in the VLOOKUP function.

4. Type a comma ( , ).

Type ,

The comma ( , ) appears in the VLOOKUP function.

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

Type prices

6. Type a comma ( , ).

Type ,

The comma ( , ) appears in the VLOOKUP function.

7. Enter the column index number. The column index number appears in the VLOOKUP function. 8. Type the closing parenthesis ( ) ). The closing parenthesis ( ) ) appears in the VLOOKUP function.

Type 2

Type )

OFFICEPRO, Inc.

Page 71