Vlookup Calculations; Set up vertical lookup tables for these three items, then complete the calculations. Unit Price: Apple, $45; Banana, $34; Grape, $89; Kiwi,$30, Orange, $20 Date Discount: Mon, 10%; Tue, 5%; Wed, 2%; Thu, 2%; Fri, 20% High Purchase Discount: From 0 up to 1000, 0%, 1000 up to 5000, 3.5%, from 5000 up to 10000, 8%, anything 10000 and above 10%. High Date Purchase Unit Discount Discount Discounted Product Quantity Sale Date Price Extension Percent Percent Price Banana 123 2-Feb-10 $34.00 4,182.00 20% 4% 3.199.23 Orange 45 4-Feb-10 $20.00 2,460.00 #REF! 4% #REF! Apple 600 4-Feb-10 $45.00 5,535.00' #REF! 8% #REF! Apple 58 4-Feb-10 $45.00 5,535.00 #REF! 8% #REF! Banana 79 8-Feb-10 $34.00 4,182.00 #REF! 4% #REF! Grape 132 8-Feb-10 $89.00 10,947.00 #VALUE! 10%' #VALUE! Kiwi 123 8-Feb-10 $30.00 3,690.00 #VALUE! 4% #VALUE! Kiwi 45 9-Feb-10 $30.00 3,690.00 #VALUE! 4% #VALUE! Banana 600 9-Feb-10 $34.00 4,182.00 #VALUE! 4% #VALUE! Orange 58 9-Feb-10 $20.00 2.460.00 #VALUE! 4% #VALUE! Apple 79 12-Feb-10 $45.00 5,535.00 #VALUE! 8%' #VALUE! Apple 58 12-Feb-10 $45.00 5,535.00 #VALUE! 8%' #VALUE! Apple 79 12-Feb-10 $45.00 5,535.00 #VALUE! 8% #VALUE! Grape 132 15-Feb-10 $89.00 10.947.00 #VALUE! 10%' #VALUE! Kiwi 123 16-Feb-10 $30.00 3,690.00 #VALUE! 4% #VALUE! Banana 45 17-Feb-10 $34.00 4,182.00 #VALUE! 4% #VALUE! Orange 600 18-Feb-10 $20.00 2,460.00 #VALUE! 4% #VALUE! Apple 58 19-Feb-10 $45.00 5,535.00 #VALUE! 8% #VALUE! #N/A #N/A #N/A #N/A #N/A Total: #REF! banana Unit Price Vlookup apple 45 34 grape 89 kiwi 30 orange 20 Date Discount Vlookup 2 10% 3 5% 4 2% 51 2% 6 20% High Purchase Discount 10000 3.50% 5000 8% 10000 10%