I have 3 different lists of pricing (MSRP, Contractor and Registered) that have different pricing for each of our part numbers. So the columns would be -- Part #, MSRP, Contractor, Registered.
What I am trying to do is to (on a second sheet in same book) is have someone select the pricing they need from a drop down menu (MSRP, Contractor and Registered). Then they will choose a part number from a drop down menu in each cell and the appropriate pricing will be shown dependent on the pricing the select.
I can get it to work with one list using data validation and vlookup but I cannot seem to figure out how to get have the pricing change between MSRP, Contractor and Registered.
Can someone help me?
What I am trying to do is to (on a second sheet in same book) is have someone select the pricing they need from a drop down menu (MSRP, Contractor and Registered). Then they will choose a part number from a drop down menu in each cell and the appropriate pricing will be shown dependent on the pricing the select.
I can get it to work with one list using data validation and vlookup but I cannot seem to figure out how to get have the pricing change between MSRP, Contractor and Registered.
Can someone help me?