State Abbr with Index+Match+Validation
February 14, 2012
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…
Fx to cut long column into two columns
Convert 2-column into wide (column-row) table
Week number to Sunday date – Weeknum reverse
About The Author
ANmar
An Excel-Passionate user, developer and teacher Love finding new ways to solve daily issues and enhances to regular users, then teach that