The cells in column I will represent the Discount %, which is based upon the # Units Sold (column F). Use the following information for your VLookup table: # Units Sold Discount% 1 to 499 1% 500 to 999 1.5% 1000 to 2499 2% 2500 to 2999 2.5% 3000 or more 3% 1) Create a 2-column VLookup Table and position it in the range K18:L22. There should be 5 rows to this table

2) Once the VLookup table is created, complete column I using the VLookup function for all records so that Excel searches for an Approximate match. The resulting values should be the correct Discount % for the given country.

What should be inputed in the Vlookup Formula?