Excel 2007 : Drop Downs

[charlieparsley]

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...

[ConneXionLost]

Hi,

Try the VLOOKUP function.

Cheers,

[NBVC]

You will need VLOOKUP function

E.g.

=Vlookup(B14,PriceList,2,0)

where PriceList is the range your price table is in...