what formula do i use in cell f9

Insert Format Debug Run Tools Window C Task Points Task Description X logicandreference-U0-Dadyn_marshall raw Page Layout Formulas Data Review View Assignment Assignment Tasks Lookup Use the VLOOKUP function in bmit View cell F9 to determine the Report number of days it will take to ship order 1. Use the distance In cell E9 to lookup the appropriate value on the D "Delivery information" reference table range K10:M15). Make sure to use oards sells outside bulletin boards used to display community Information on the outside of buildings. They sell blu relative and absolute alles while they offer a discount for purchasing in bulk, they require customers to buy at least two bulletin boards references appropriately. [6 the boards ordered, the number to be shipped with the order, and the distance of the delivery in miles Complete the points! ulate the number of days it will take for delivery, the delivery price, and the price of thesis for each order Hiver La fun #Days Delivery Price Delivery Information Miles Day Price 0 1 $20.00 50 Z $3000 100 3 $50.00 5 $75.00 400 7 $150.00 NOD $400.00 200 Color Red Blue Red Red Red Blue Red Blue Blue Blue Red Blue Blue Blue Blue Product Prici Shipped Blue 2 $300 3 $400 5500 5 $600 6 5700 7 5800 8 5900 9 $1,000 10 51.100 Shipped Distance 4 845 10 421 5 5 7 883 4 181 9 117 7 867 9 17 6 646 2 486 9 195 6 374 4 74 7 17 0 822 9 940 4 140 3 56 10 823 2 705 7 54 Total $0 $0 so 50 $0 50 $0 $0 SO $0 50 $0 30 $0 50 $0 $0 $0 $0 $0 $0 Blue Red Blue Red Blue Red Hinton Task 5. Note that the 3rd argument within the HLOOKUP func row_index_num. It specifies how many rows to go down within them column to find the right value to return as the function result Task to use the rowIndex number argument slightly differently than web problem for each Order, the shipped value specified in Column Dh be the desired Row Index_num for that order when the table_array is correctlyYou should refer to the respective Column D cell for the HLOOKUP rpment. Therewindex_num argument will be a referenc in column rather than a fixed number Functions IF Function Lookup Functions Conditional Functions + Average: 165.5789474 wed Count: 19 7 MT 17 Sum: 3146 5450 1 10 $150 7 SIM S12 S100 5100 $700 $100 $1425 5145 10 11 4 35 5 4 4