The Lookup Function

Say your company offers a bonus for meeting sales goals. The bonus will be calculated as a percent of the sales.

 

The best way to calculate the bonus is to look up the answer in a table. Excel calls this the Lookup function. A vertical, or VLookup uses the values in the columns. A horizontal, or HLookup, uses the data in rows.

 

1. Try it: Create a VLookup Table

Go to the Bonus spreadsheet.

Add the following labels:

In cell C1, type Commission

In cell D1, type Bonus

In cell F1, type Sales

In cell G1, type Percent

 

Format the Labels Bold.

Format Column F for Accounting.

Format Column G for Percentage.

 

Keep going.

Exam 77-882: Microsoft Excel 2010 Core

5. Applying Formulas and Functions

5.1. Create formulas

Home -> Number