PLEASE ANSWER IN EXCEL AND PROVIDE CODE IN EXCEL

Use the table "COGS" to Complete the Column "COGS" (column H) in the "Transaction Entry" table. Hint: use vlookup (6%)

Calculate the profits in the "Transaction Entry" table for each transaction (column I), Profit = Units (SalesPrice - COGS). (6%)

This tubls: "Tranca:ion Futry" bospe cach iranctetion mase: hy cach salzs fisckerourd atpesearaniveh. The Salespaice and COCS are bsth sef per unit af paods.CCOGS: The of tiond solit Calsu'sic the profile in the "Trarsactien Friry" bolle fir cach irsesetion stcc2 This tubls: "Tranca:ion Futry" bospe cach iranctetion mase: hy cach salzs fisckerourd atpesearaniveh. The Salespaice and COCS are bsth sef per unit af paods.CCOGS: The of tiond solit Calsu'sic the profile in the "Trarsactien Friry" bolle fir cach irsesetion stcc2