1. Calculate profit margins (as a percentage) for each product in column L. 2. Extract the second word from product Name. For example, for productID "AP398", it would be the word "Authentic". 3. Answer the queries on Queries sheet. 4.Create a drop down menu for all the Product IDs from the Products DB and Then using a product ID, you should be able to Look up rest of the information about the product.
Solved by A. J. in 12 mins