Hy there!

I am trying to pull some data from another sheet, in my main sheet, in order to change some prices of produs, depending the type of them.
In another sheet i put the products in one column, price for type1 in second column, price for type3 in third column, and price for type3 in fourth column.
In the main sheet, I created a dropdown list to select the thype o products the customer whants, and I would like the prices to change when I change de selection in my dropdown list. I tried to write a function using vlookup and ifs, but I can't manage well this. Is there another way, maibe even VBA codes, to do this?

Thanks and sry if this subject was before, I didn't find it.