please help and show work! excel sheet included as well. thanks!

B18 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 1 2 3 Customer Address 5 City 6 State 7 Zip Code & Phone NL 9 Email Add 10 11 Product 12 Ramekin 13 Mesh slove 14 Measuring ou 15 Ladie 16 Grue 17 Garlic press 18 Foil wrap 19 copper pot 2017 copper FERRANXXX NAAR Page 21 22 23 21 26 27 Copy the formula in D12 to D13:D20. B18 fx Red E D Order - Invoice Date: 11422 Malta 23 Sunshine Road INDONO Customer Name Address 5 City State Zip Code Phone Number Email Address HI 308 614-03 Boumat.com Column number based on Color Product ID Price for Quantity $5.00 Color Choice Dia 1 11 Product Name 12 Ramin Mesh 14 Mingo 15 de G 17 Garlic Vlow Green w Bu Red Yellow $500 Quantity Unit Price $5.00 $5.00 0 $5.00 0 $5.00 0 $5.00 0 $5.00 0 $5.00 0 $5.00 Subtotal Total Order (510 is the Minimum Orden State Sales Tax Rate 7.50% State Sales Tax Shipping Charge (Waived if order exceeds $99) Invoice Total Foil wr 2 19 copper por 2017 ge 21 22 $5.00 $10.00 23 $.75 $.80 $11.55 23