Problem and be very tedious. The best way is to use VLOOKUP to fill in the first row of missing data and then drag down to fill the remaining rows. range$\_$lookup parameter to FALSE.

What is the Product ID returned in cell $C2?$

B$07$NQKQ$19$S

Now repeat this process for the missing Unit Price in cell D$2.$ What is the unit price returned in D$2($to the nearest cent$)?$

And finally, for the first item, calculate the Gross Sales in column E using Order Quantity from column B and Unit Price from Column D$.$ What is the gross sale amount in cell E$2?$

$ remaining $147$ items in columns C$,$ D$,$ and E have been completed using a lookup table, two VLOOKUP formulas, a simple math formula, and Excel's fill down feature.