If , vlookup and drop down list

IonutD

New member
Joined
Mar 27, 2020
Messages
2
Reaction score
0
Points
0
Excel Version(s)
2019
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.
 
Sorry - I can't open your workbook as it's throwing up a potential security risk message. I won't risk it - I'm not prepared to.
 
Is this what you are trying to do? I've used INDEX/MATCH to do the equivalent of a VLOOKUP, along with INDIRECT to select the correct column in the price table.

Norm
 

Attachments

  • PriceSelectionWithDropdown.xlsx
    13.2 KB · Views: 13
Back
Top