using HLOOKUP function, but i cant see what im doing wrong. i feel like i should use each row but it doesnt work still.

HLOOKUPICODS.OS:1.1ALSE) c F G M N O The CWU WY regionally up to 1000 miles. While they offer a discount for purchasing in bulk, they require customers to buy at least two bulletin boards at a time. The table below lists 25 recents Each order lists the color of the boards ordered, the number to be shipped with the order, and the distance of the delivery in miles. Complete the table by using the VLOOKUP and HLOOKUP functions in Excef to calculate the number of days it will take for delivery, the delivery price, and the price of the sims for each order Price Color Red Blue Red Order 1 2 3 4 5 6 7 B Delivery information Miles Day 1 $20.00 50 2 $10.00 3 550.00 200 5 525.00 100 7 $150.00 DO 8 $400.00 SRO 100 Product Pricing w Shipped Blue Red 2 $300 $500 $400 5200 $500 5800 5 Scoo 5975 6 $200 $1,100 7 $800 $1,200 5900 $1,350 51,000 $1425 10 51.100 $1.550 117 Blue Red Blue Blue Blue 9 10 11 Red Shipped Distance #Day Delivery Price Total 4 345 SE VALUEINVALUL! 19 421 7 5400 S100 5 5 1 30 $0 7 883 8 SHOD 181 3 S100 STOD 9 $100 $100 > 362 $300 SBD 1 50 50 6 646 2 S400 S100 2 2 STOD SAOB 9 195 $100 $100 5 5200 $200 4 76 2 $50 7 32 1 50 50 D a S300 $100 000 $800 SROD 4 140 $100 $100 1 56 2 550 550 90 23 B S800 SHO 2 705 $400 $400 2 st 2 $50 $50 3 35 1 SO 50 4 $400 S100 If Function Lookup Functions Conditional Functions Be Blue 30 17 550 15 Blur 16 Blue 17 Red 1 Blue Red 20 stu 21 Ted 22 ed Red Boolean functions Hinton TakNot that the argument within the HLOOKUP function is the row indevum. 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 to use the rowIndex Imberuments differently than we have in prior problem. For each Order, the Shipped vale specified in Column pens to be the desired Row_index_num for that order when the table any specified correctly, you should refer to the respective Column cell for the HLOOKUP arenent). The row_index_nument will be a reference to a cincolumn cother than a fixed number Type here to search