Small file that will show how to do INDEX + MATCH formulas to get the abbreviation of the state based on its name or the name of the state based on its abbreviation
Main formula to do that is:
=INDEX(Abbr_States,MATCH(B4,States,0),1)
That is in addition to the Names created…
