I was wondering what excel tool or function I would use if I wanted to be
able to select a word from a data validation cell, in this case metals for
example

Copper
Aluminium ... etc

Once a metal had been chosen, certain cells in my sheet would take
appropriate preset values.

For example if copper was selected then the cells labelled conductivity,
weight... etc would then change to their set numerical values.

The only way I can think of is using a whole series of IF statements, i.e.
IF cell a1 = Copper, cell value = 0.0000465. But this does not seem like a
very eloquent way of doing it.

Thanks in advance,

Michael