The values provided to CHOOSE can be hard-coded constants or cell references.
The first argument for the CHOOSE function isindex_num.
This is a number that refers to subsequent values by index or position.
The next arguments,value1,value2,value3, etc.
are the values from which to choose from.
Choose can handle up to 254 values.
However, CHOOSE will not retrieve an item frominsiderange or array constant provided as a value.
More than one condition can be tested by nesting IF functions.
Use the IFS function to evaluate multiple conditions without multiple nested IF statements.
When no match is found, SWITCH can return an optional default value.
VLOOKUP supports approximate and exact matching…
