Spreadsheet Help!

nousername

Active Member
Joined
Feb 15, 2015
Messages
225
Reaction score
102
Points
43
Location
Abu Dhabi, but from Glasgow
Supports
Rangers
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 simplifying it for this post.)

Can anyone help?
 

Veggie Legs

Well-Known Member
Joined
Jan 19, 2015
Messages
3,337
Reaction score
1,590
Points
113
Location
Norwich
Supports
Ipswich
I think you want to use VLOOKUP, I'm sure you can find a tutorial that it explains it better than I could.
 

Forum statistics

Threads
16,652
Messages
1,243,721
Members
8,536
Latest member
ownedbyrabbits
Top