Matching Value from a List of Products

[Syer]

Hi,

I have an excel sheet that's filled with all product details. Example as per below:

Basically it's separated into retail and private products. So i would like to create a section at the top of the sheet that is sort of like a summary where it can provide the details of a product based on their product code such as this:
Presentation

Product Code	Initial Price	Max price	Purchase date	Discount	Month	Date	Selling Price
7​	10.00	21.00	2-Feb-20	6%	1	2-Feb-20	18

And here are the issues that I need help with:

Problem 1:
For the product code in the presentation part, I only managed to do a drop down button by creating a list of all product codes. How do i create a list for the product code for different rows?

Problem 2:
For the other columns in presentation part, I did a vlookup as usual but is there any other way to display the values based on the product code (from the drop down button)?

Do let me know if you have any ideas for this worksheet or how to simplify this process further.

Thank you in advance!

 

[ExcelGzh]

I'm going to need some clarification here.

"I only managed to do a drop down button by creating a list of all product codes". Yes, that is how you populate a dropdown box - you have to have a list somewhere.

"How do i create a list for the product code for different rows?". This is the bit I don't understand. I presume you made the dropdown list manually - or did you use some vba code? If you are making the list manually, what is the difficulty with multiple rows?