07-30-2019 01:41 AM
07-31-2019 03:41 AM - edited 07-31-2019 03:44 AM
I attached a sample file
The drop list (data validation ) in column A is changing Product
In Column B I have a Vlookup & Match Function extracting the Price from a Master List
Also the Label in Cell B2 is another drop list >. so if you switch that label from Price to color all the Vlookup functions return colors
Conclusion the you should have a master list with all data and then using a drop list & a Vlookup function you pull out what you need.
Hope that helps