VLookup and change output

RJB78

Board Regular
Joined
Aug 8, 2016
Messages
54
Hello. I have a vlookup function looking up American citys/towns and returning the full state name that they are located in. How can I pull in the full state's name (how the data comes in), but then have it display the abbreviated state's name. Example: Florida -> FL. LEN( doesn't always work.

I have a separate tab with the full states name in column A, and abbv. in column B

Thank you
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
30,198
Office Version
365
Platform
Windows
You can nest the vlookups like
=VLOOKUP(VLOOKUP(city,state,2,0),abbr,2,0)
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
30,198
Office Version
365
Platform
Windows
You're welcome & thanks for the feedback
 

Forum statistics

Threads
1,077,772
Messages
5,336,150
Members
399,067
Latest member
CJWFM

Some videos you may like

This Week's Hot Topics

Top