See the attached. I have two tabs. One for data entry (Entry) and one for options that can be selected (Hidden) under the category (C3) and subcategory (D3) on the Entry tab. I have managed to create two dropdown lists. One for Category, data selected from Hidden column A. and the other for my subcategory, data selected from Hidden column B base on the category selection from Entry C3. What I would like to do is have Entry E3 automatically populate the price from the cell directly to the right of the subcategory on the Hidden tab. In this case my subcategory is “cabinets (mobile)”, so E3 would return the cost $110.00 in Hidden C5.
I hope I am making sense.
Any Help?
Dynamic Drop Down.xlsx