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.