how to make a list with products and prices

[excelhelp]

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!

[#2]

Read this:
https://support.office.com/en-us/article/vlookup-function-0bbc8083-26fe-4963-8ab8-93a18ad188a1?NS=EX...

[#3]

Hi @excelhelp  

Its simple, click on Data  ---> Data Validation ---> List ---> define the range of list.

Pictorial illustration along with sample excel file is attached for more clarity and understanding: Thanks, Tauqeer

[#4]

Tanx@tauqeeracma 

I can make that list, but when I select a pear, the price doesn't change along.

[#5]

Tanx@JKPieterse perhaps I am not following the instructions correctly, because it doesn't work. I get an error in the formula.

[#6]

Which error do you get?

[#7]

@excelhelp 

I selected 'Pear' and the price got changed.

Alternatively, you can share your file with list of values you need in a drop down list. Thanks

[#8]

@excelhelp 

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

[#9]

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?

[#10]

Look in Help for the XLOOKUP function. If you do not see that function, try the VLOOKUP function instead.

[#11]

@nabilmourad