Use the VLOOKUP function in cell F3 to determine the number of days it will take to ship order 1. Use the distance in cell E3 to lookup the appropriate value on the "Delivery Information" reference table (range K4:M9). Use relative and absolute references appropriately.

A B D E F G H K L M N O P Order # #Days Delivery Price 1 2 3 4 #Shipped Distance 4 845 1 2 421 5 3 3 Color Red Blue Red Red Red Blue Red 10 5 5 7 5 Delivery Information Miles #Days Price 0 1 $20.00 50 2 $30.00 100 3 $50.00 200 5 5 $75.00 400 7 $150.00 800 8 $400.00 6 4 883 7 5 4 181 Product Pricing #Shipped Blue Red 2 $300 $500 3 $400 $ $700 4 $500 $800 5 $600 $975 6 $700 $1,100 7 $800 $1,200 8 $900 $1,350 9 $1,000 $1,425 10 $1,100 $1,550 8 6 9 117 9 7 7 867 17 10 8 9 11 9 6 646 12 10 2 486 13 11 9 195 14 12 6 374 Total 0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 15 13 4 74 16 14 S 7 17 17 6 822 15 16 18 9 Blue Blue Blue Red Blue Blue Blue Blue Blue Red Blue Red Blue Red Red Red Red Red 940 19 17 4 140 20 18 3 56 19 10 21 22 823 705 20 2 7 23 21 54 22 3 35 24 25 23 4 684 26 24 9 60 27 25 6 86 28 29 30