Question
November 12, 2007 at 04:33 PM
johnmotson

Creating a dropdown list that coresponds to different cells

by johnmotson . Updated 18 years, 10 months ago

I would like to know how to create a drop down list for a specified set of values, I want these values to correspond to a different value
for example

Rough Concrete corresponds to 0.8

so when i select the name such as rough concrete the value 0.8 appears in a cell below the drop down menu, however i would like all the values to appear in the same cell

Any response would help me greatly
Thankyou for your time and effort

This discussion is locked

All Comments