This is probably quite simple, but I'm not getting the answers on the web.
On a tab on spreadsheet I have a list of codes, i.e. 1=A, 2=B, 3+C etc.
On another tab I want to make it so that if I type in '1' beside some spreadsheet data 'A' appears.
(Obviously the info is quite detailed, just...