This will work for a few cells, but I have multiple states and multiple
cells. I am looking for a way to use the full list of states and
abbreviations, and compare to every cell I import with a State's name in it.
For example, if cell A1 is New York, the formula would change it to NY, but
if cell A1 is Rhode Island, the answer would be RI.
If you have a list of states and its abbreviations in Sheet2 say colA and B
try the below instead
If A1 is having state; insert an additional column and use the below formula.
=VLOOKUP(A1,Sheet2!A:B,2,FALSE)
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.