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 has been sitting for a …
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 name of the state based …
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 states and a technique (INDEX …
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 from a large table in …
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 do also. What you need …