You are currently browsing the football forums as a guest. Sign up now for free and benefit from totally ad-free browsing. Logged in members see no ads.

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
15,665
Messages
1,031,081
Members
6,114
Latest member
ahmad hayat khan

Latest posts

Top