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
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!
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!