Built$-$tough Boards sells outside bulletin boards used to display community information on the outside of buildings. They sell blue and red bulletin boards which they will

$25$ recent sales. 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 Excel to calculate the number of days it will take for delivery, the delivery price, and the price of the signs for each order.

Hint: This is a challenging task, but it shows the power of HLOOKUP $($and VLOOKUP as well$).$ Use

the billboard color as your "lookup$\_$value". The "lookup$\_$value" is used to find a match on the

lookup table. The "table$\_$array" must start in row $9$ because that is where "Blue" and "Red" are

located. When using HLOOKUP, Excel always looks for a match to the "lookup$\_$value" in the first

row of the "table$\_$array". The "row$\_$index$\_$number" is the row of the "table$\_$array" from which you

return the appropriate pricing. In this case, the lookup table is arranged so that the row number of

the table corresponds with the quantity shipped $($the price for buying $2$ billboards is on the second

row of the reference table$).$ Therefore, you can use the $"$# Shipped" from the information you have

on the table as the "row$\_$index$\_$number".