Forum Discussion
how to make a list with products and prices
how do I make e productlist (dropdown) with the right price? So if I select for example banana, I want that the next cell automatically gives the right price for the banana. Is that possible? Tanx!...
Hi
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
=VLOOKUP(A3,$D$3:$F$27,MATCH($B$2,$D$2:$F$2,0),FALSE)
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
Nabil Mourad
- Hi, I'm looking for a similar solution but can't figure it out.
I have a "Parts" column and a "Value" column. When I select a part, I would like the value cell to automatically update with the correct price.
I have another sheet with a table containing the parts and a value - this is where the data needs to come from.
Can anyone help?- Look in Help for the XLOOKUP function. If you do not see that function, try the VLOOKUP function instead.
