Look things up
Pick from a short list by number
=CHOOSE(A2,"Low","Mid","High")How it works in Excel
- A2 is a number.
- 1 gives the first item, 2 the second, and so on.
- A number past the end of the list gives #VALUE!.
The idea in general
It is like a vending machine: press a number and get that item.
What I assumed
- The number is in A2.
Check the result on your own data before relying on it.