What's formula to solve H9 using hlookup function also need to drag down column H

H9 x A B D E F . 1 1 M N 0 Q R 7 8 9 10 Order # 1 Price # Shipped Distance 4 845 10 421 5 5 7 883 # Days 8 7 2 11 3 4 1 8 3 Delivery Information Miles # Days Price 0 1 $20.00 50 2 $30.00 100 3 $50.00 200 5 $75.00 400 7 7 $150.00 800 8 $400.00 4 12 13 14 15 15 5 6 Total $150 $20 $400 $50 $50 $400 $20 para $150 $150 $50 9 Product Pricing # Shipped Blue Red 2 $300 $500 3 $400 $700 4 $500 $800 5 $600 $975 and $ 6 $700 $1,100 7 $800 $1,200 8 $900 $1,350 9 $1,000 $1,425 10 $1,100 $1,550 3 7 7 8 Delivery $150 $20 $400 $50 $50 tan $400 $20 ter $150 $150 $50 $75 $ $30 --- $20 $400 $400 181 442 117 867 . 17 646 4oc 486 195 8 9 9 10 10 11 1 7 7 3 2 9 5 12 13 Color Red Blue Red Red Red Blue Red Blue Blue Blue Red Blue Blue Blue Blue Blue Red Blue Red Blue Red Red Red Red Red 6 4 2 1 14 374 . 74 17 822 940 7 16 17 17 10 18 19 20 20 21 22 23 24 25 26 26 27 28 29 30 31 32 33 34 35 36 6 9 8 8 8 3 3 2 4 3 15 16 17 18 90 19 20 21 22 23 140 56 823 70- 705 54 $75 $30 $20 $400 $400 $50 $ $30 $400 $150 $30 $20 $150 $30 $30 $20 10 Hint on Task 5. Note that the 3rd argument within the HLOOKUP function is the row index num. It specifies how many rows to go down within the matching column to find the right value to return as the function result. Task 5 requires us to use the row_index_number argument slightly differently than we have in prior problems. For each Order, the #Shipped value specified in Column D happens to be the desired Row_index_num for that order when the Table_array is specified correctly (i.e., you should refer to the respective Column D cell for the 3rd HLOOKUP argument). The row_index_num argument will be a reference to a cell in column Drather than a fixed number 8 $50 $30 can $400 $150 $150 --- $30 $20 $150 $30 $30 $20 2 7 7 2 1 3 4 35 684 60 9 24 25 7 2 2 6 86 Activate