Parsing list of state names and abbreviations
What am I doing wrong in setting up this formula?
Vlookup Question.jpg
I'm doing a State lookup from a colum that contains state names spelled out and 2 digit abbreviations. If the state is spelled out I want to find the abbreviation in the table. If it's already the abbreviation I just want to copy it to the next column to the right.
IF(A1>2,"=Vlookup(A1,C1:C50,D1)",B1=A1)
Thanks for your guidance!
Steve
In B1 cell
Formula:
=IF(LEN(TRIM(A1))>2,IFERROR(VLOOKUP(A1,C1:D50,2,0),"No Match Found"),A1)
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Thanks so much!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks