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,662
Messages
1,244,517
Members
8,540
Latest member
Carl
Stronger Security, Faster Connections with VPN at IPVanish.com!

SITE SPONSORS

only at Infinity View IPTV .net
W88 W88 trang chu KUBET Thailand
Fun88 12Bet Get top UK casino bonuses for British players in casinos not on GamStop
The best ₤1 minimum deposit casinos UK not on GamStop Find the best new no deposit casino get bonus and play legendary slots Check out UBEAMTV IPTV
No-Verification.Casino Justuk's list of 100 non gamstop bookies Bideford's only UK non gamstop casino reviews
miglioriadm.net: siti scommesse non aams Casinos that accept PayPal Top online casinos
Top