Excel: Work Smarter Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20

Create the Lookup Table Your Lookup table has two columns: Sales and Percent.   Try it: Add data to the Lookup table Select column F and format it for currency. Select column G and format it for Percent.   Enter the following values: Sales Percent  $  2,500.00 5%  $  5,000.00 10%  $  7,500.00 15%  $10,000.00 20%