VLookup and change output

[RJB78]

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]

You can nest the vlookups like
=VLOOKUP(VLOOKUP(city,state,2,0),abbr,2,0)

 

[RJB78]

Of course, was over thinking it. Thank you

 

[Fluff]

You're welcome & thanks for the feedback