( Use the HLOOKUP function in cell (H3) to calculate the product pricing based on the...

 

Transcribed Image Text:

( Use the HLOOKUP function in cell (H3) to calculate the product pricing based on the color and quantity of the billboards ordered. a. Product pricing can be referenced on the "Product Pricing" lookup table (range P3:Q12). b. Use appropriate relative and absolute cell references. c. Note the third 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. For each Order, the value specified as '#'Shipped in Column D is the desired Row_index_num for that order (i.e., you should refer to the respective Column D cell for the third HLOOKUP argument). The row_index_num argument will be a reference to a cell in column D rather than a fixed number. A B Order # 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 с 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 D #Shipped 4 10 5 7 4 9 7 9 6 2 9 6 4 7 6 9 4 3 10 2 7 3 4 9 6 E Distance 845 421 5 883 181 117 867 17 646 486 195 374 74 17 822 940 140 56 823 705 54 35 684 60 86 F # Days 8 7 1 8 3 3 8 1 7 7 3 5 2 1 8 8 3 2 8 7 2 1 7 2 2 G Delivery $400 $150 $20 $400 $50 $50 $400 $20 $150 $150 $50 $75 $30 $20 $400 $400 $50 $30 $400 $150 $30 $20 $150 $30 $30 H Price I Total $400 $150 $20 $400 $50 $50 $400 $20 $150 $150 $50 $75 $30 $20 $400 $400 $50 $30 $400 $150 $30 $20 $150 $30 $30 J K L M Delivery Information Miles # Days 0 1 50 2 100 3 200 5 400 7 800 8 Price $20.00 $30.00 $50.00 $75.00 $150.00 $400.00 N O P 4 5 6 7 8 9 10 Product Pricing #Shipped Blue 2 $300 3 $400 Q Red $500 $700 $800 $975 $700 $1,100 $1,200 $800 $900 $1,000 $1,350 $1,425 $1,100 $1,550 $500 $600 R ( Use the HLOOKUP function in cell (H3) to calculate the product pricing based on the color and quantity of the billboards ordered. a. Product pricing can be referenced on the "Product Pricing" lookup table (range P3:Q12). b. Use appropriate relative and absolute cell references. c. Note the third 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. For each Order, the value specified as '#'Shipped in Column D is the desired Row_index_num for that order (i.e., you should refer to the respective Column D cell for the third HLOOKUP argument). The row_index_num argument will be a reference to a cell in column D rather than a fixed number. A B Order # 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 с 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 D #Shipped 4 10 5 7 4 9 7 9 6 2 9 6 4 7 6 9 4 3 10 2 7 3 4 9 6 E Distance 845 421 5 883 181 117 867 17 646 486 195 374 74 17 822 940 140 56 823 705 54 35 684 60 86 F # Days 8 7 1 8 3 3 8 1 7 7 3 5 2 1 8 8 3 2 8 7 2 1 7 2 2 G Delivery $400 $150 $20 $400 $50 $50 $400 $20 $150 $150 $50 $75 $30 $20 $400 $400 $50 $30 $400 $150 $30 $20 $150 $30 $30 H Price I Total $400 $150 $20 $400 $50 $50 $400 $20 $150 $150 $50 $75 $30 $20 $400 $400 $50 $30 $400 $150 $30 $20 $150 $30 $30 J K L M Delivery Information Miles # Days 0 1 50 2 100 3 200 5 400 7 800 8 Price $20.00 $30.00 $50.00 $75.00 $150.00 $400.00 N O P 4 5 6 7 8 9 10 Product Pricing #Shipped Blue 2 $300 3 $400 Q Red $500 $700 $800 $975 $700 $1,100 $1,200 $800 $900 $1,000 $1,350 $1,425 $1,100 $1,550 $500 $600 R

Answer rating: 100% (QA)

In order to calculate the product pricing based on the color and quantity of the billboards ordered ... View the full answer