graphic2

Exam 77-427 Microsoft Excel 2013 EXPERT
3. Create Advanced Formulas
3.2 Look Up Data with Functions: Use The LOOKUP Function

graphic1

Create the Lookup Table

This Lookup table has two columns: Sales and Percent.

 

2. Try it: Add data to the table

Enter the following values:

Sales

Percent

 $  2,500.00

5%

 $  5,000.00

10%

 $  7,500.00

15%

 $10,000.00

20%

Keep going, please...