please show full work thank you

1 C 4 A 4. In D12:D20, use VLOOKUP functions to find Product IDs. Using D12 as an example: a. lookup_value is A12 b. table_array is Product ID table C. column_index is C12 + 1 C12 is the relative position of the color choice amongst all colors. Since the first column is for the product name and not a color choice, the column index is the position of the color choice plus 1. d. range_lookup is FALSE for an exact match SI 7 zig OPN o En P 12 am 13 Mar 14 M 15 Lade 10 17 Garlie 10 Follow 19 2012 SOONDOORSPRCOPRANARRRRRRRRRRR Page 1 22 25 27 Copy the formula in D12 to D13:D20. C27 A D Order involce Date: 31422 Customer Name Address 5 City 6 State 7 Zip Code Phone Number . Email Address 10 Kor Ort 333 Sanchino Rod Ewa Beach How 2010 100514-1923 O.com Color Choice Column number based on Color Product ID Price for Quantity $5.00 Red 6 11 Product Name 12 Ramekin 19 Mesh HP ANH MINH 15 de 16 17 Gare pre 10 Few 10 copper 2017 april 4 15.00 EODELSER ENRRRRR WW w Red Yew Quantity Unit Price 1 $5.00 0 $5.00 35.00 15.00 $5.00 0 0 $5.00 O $5.00 0 5.00 Subtotal Total Order $10 the Minimum Order State Sales Tax Rate 7 50% State Sales Tax Shipping Charge (Wave order exceeds 599) Involce Total 2 $5.00 $10.00 24 5.75 5.80 $11.55 1 C 4 A 4. In D12:D20, use VLOOKUP functions to find Product IDs. Using D12 as an example: a. lookup_value is A12 b. table_array is Product ID table C. column_index is C12 + 1 C12 is the relative position of the color choice amongst all colors. Since the first column is for the product name and not a color choice, the column index is the position of the color choice plus 1. d. range_lookup is FALSE for an exact match SI 7 zig OPN o En P 12 am 13 Mar 14 M 15 Lade 10 17 Garlie 10 Follow 19 2012 SOONDOORSPRCOPRANARRRRRRRRRRR Page 1 22 25 27 Copy the formula in D12 to D13:D20. C27 A D Order involce Date: 31422 Customer Name Address 5 City 6 State 7 Zip Code Phone Number . Email Address 10 Kor Ort 333 Sanchino Rod Ewa Beach How 2010 100514-1923 O.com Color Choice Column number based on Color Product ID Price for Quantity $5.00 Red 6 11 Product Name 12 Ramekin 19 Mesh HP ANH MINH 15 de 16 17 Gare pre 10 Few 10 copper 2017 april 4 15.00 EODELSER ENRRRRR WW w Red Yew Quantity Unit Price 1 $5.00 0 $5.00 35.00 15.00 $5.00 0 0 $5.00 O $5.00 0 5.00 Subtotal Total Order $10 the Minimum Order State Sales Tax Rate 7 50% State Sales Tax Shipping Charge (Wave order exceeds 599) Involce Total 2 $5.00 $10.00 24 5.75 5.80 $11.55