Im working with a drop down menu in my "Master Bedroom" sheet, cell B14. I have a few options to choose from.... My question is, When I chose an option, i want it input a price in a different cell from my "price book" sheet. There is a price for each item in my drop down. For example, B14 has three drop downs, 8' 12' and 0,,, I have prices on a differnt sheet, "price book" sheet (same file). in B16 if i select 12' i want a price of 4.25 from my "price book" C4, to be placed in B16 cell of "Master Bedroom". If 8' is selected I want 3.70 from my "price book" C3 to be placed into B16... can anyone help...
Bookmarks