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,399
Messages
1,185,852
Members
8,251
Latest member
Jack Whitham 3

Latest posts

Stronger Security, Faster Connections with VPN at IPVanish.com!

SITE SPONSORS

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 Best UK online casinos list 2022
No-Verification.Casino Casinos that accept PayPal Top online casinos
sure.bet
Top