You can use data validation, and vlookup formulas to do this. There are
instructions in Excel's Help, and he

http://www.contextures.com/xlDataVal01.html

http://www.contextures.com/xlFunctions02.html

and instructions for an order form that uses this technique he

http://www.contextures.com/xlOrderForm01.html


Nigel wrote:
Hi,
i have a question if anyone can help me with using data validation. i have a
column range ( C6:C30) i want to set it up so it gives me a drop down list
with the following content
mdf
birch ply
small glass shelves
large glass shelves
opal acrylic
clear acrylic
metal frames
ali channel

in the next column (e6:e25)

the costs
£8.50
£14.50
£25.00
£40.00
£33.00
£33.00
£65.00
£22.00

basically, i want to be able to select a material, and the cost alters
accordingly in the next column. i would like the information to be added on a
separate sheet called material data that i can update.

if anyone can help, it would be a great help.



thanks,

n.s.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html