I've created a spreadsheet with a drop down list, however, i want the user
to be able to select an from a list of options, which would then poplulate
the cell with an associated code

If they selected "slate" from the list below, the information put into the
cell would be SL, any idea or advice on how i do this?

Kindest regards

Marta


Slate SL