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'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?
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.