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.
 
Stronger Security, Faster Connections with VPN at IPVanish.com!

Forum statistics

Threads
16,103
Messages
1,116,513
Members
7,188
Latest member
forest

Latest posts

Top