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
Bookmarks