Using It in Older Excel
Key points
- Choose SWITCH
- Enter the pairs
- Use the second formula
SWITCH Builder also shows a formula for older Excel that lacks SWITCH.
Steps
- Choose SWITCH
- Enter the pairs
- Use the second formula
It combines INDEX and MATCH.
Use "Build a SWITCH Formula" (free)
Tools that go well with this
- Build an IF Formula: Build an IF formula.
- Build a VLOOKUP or XLOOKUP Formula: Build VLOOKUP and XLOOKUP formulas.
- Build an INDEX and MATCH Formula: Build INDEX and MATCH formulas.