Searching table in 2 dimensions.
Using VLOOKUP + MATCH (HLOOKUP + MATCH, OFFSET + 2 MATCHes or INDEX + 2 MATCHes) to search a table in both axis. This post...
State Abbr with Index+Match+Validation
Small file that will show how to do INDEX + MATCH formulas to get the abbreviation of the state based on its name or the...
Zipcode-State search
Enter a zip code, and Excel will tell you in which state it is It also has a list of all zip codes for all...
Dynamic selection list
Using Index and CountA Formulas, Names and Forms > ListBox to have a list with connected formulas Can also be used as form to read...
Sort list dynamically (functions)
Sorting a list automatically using formulas, with no need to press the sort command Also if the source table is changed, the destination table will...