Connected product list with pricelist with autocomplete for the latter

[Kaptsea]

Hello there!

I have 2 lists. One list of products and another list with the prices for said products.

I want excel to auto complete the price for the product selected from a drop down list, to another cell nearby so you can get the cost in the end.

Pleas help

[AliGW]

So, you need to create a data validation drop-down list for the product, and then use VLOOKUP or INDEX/MATCH to fill in the price. Do you have a sample sheet?

[Kaptsea]

https://www.dropbox.com/s/3e9nv5qtkz...heet.xlsx?dl=0

Thanks for the help!

This is the sample sheet! It gets complicated after I did what you said. I now want to select the productgroup from the list CODE with a drop down, then select the product from the respective productgroup table with a dropdown, and still be able to calculate the prices in the end.

I feel bloated!