Fill Col B based on Col A text

[Ratmak]

Hi, all!
I'm sure this is an easy thing to do, but I just can't figure it out. Here's the deal:

Client has a list of data that's currently sorted by State Abbreviation. Unfortunately, sorting alphabetically by the two-letter State Abbreviation doesn't give you the same order as by the full name of the state [e.g. Alabama - AL, Alaska - AK]. For some reason, Client now needs to be able to sort by full state name.

Since I have the first column [abbreviations] already set up - it actually uses a drop down list to select from - can I write a function that will read Col A's text and fill Col B with the correct full state name? Is this a VB thing? I'm a little lost

Thanks so much for reading, and even more for helping!

[Marcol]

Try this

1/. Create a Lookup Sheet with the State Names & Codes

2/. Create named ranges within this sheet.

3/. In the sheet you wish to find full State Names
Assuming your State Codes are in Column A and the literal name goes in Column B

In B2

Please Login or Register  to view this content.

Drag/Fill Down

"CodeList" is the name given, in this demo, to the whole lookup table.

4/. "Codes" is the named range used for the Data Validation in Column A. (Abreviations)

Hope this helps