I wish to create an interactive spreadsheet where the user can choose a material from a drop down list, eg steel, brass, etc, and a characteristic of the material, eg its coefficient of thermal expansion, will be inserted into the adjacent cell to be used in a calculation.
For example, my idea is that in cell A5 there is a drop down listing steel, brass, etc. When the user chooses one of the items on the list, its name appears in cell A5 and its coefficient of thermal expansion is automatically entered into cell A6.
I am sure this is possible but I am not sure where to start reading help files.