Excel 2016 Tips and Tricks

Lesson – Using Advanced Functions

Excel 2016

Creating a VLOOKUP function

NOTE To copy a VLOOKUP function to other cells, its table array argument must be an absolute reference. Since named ranges are always absolute references, you can assign a name to your lookup table and use that name in the VLOOKUP function.



P ROCEDURES

1. Select the cell in which you want the result of the VLOOKUP function to appear. 2. Type =vlookup and an open parenthesis ( ( ). 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 column index number. 8. Type the closing parenthesis ( ) ). 9. Press [Enter] .



S TEP - BY -S TEP From the Student Data directory, open SALES72.XLSX . Use the VLOOKUP function.

Page 70

OFFICEPRO, Inc.