Matching Numbers
Key points
- Enter numbers
- See the formula
- Check it
In SWITCH Builder you can match numbers too, such as 1=Low and 2=Mid.
Steps
- Enter numbers
- See the formula
- Check it
Numbers stay as they are and text gets quotation marks.
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.