The CHOOSE function allows you to pick one value from a list of arguments based on a numeric position. It is a powerful tool for creating dynamic reports and conditional lookups.
Gör det med AISelect the target cell
Click on the cell where you want the result of the CHOOSE function to appear.
Enter the CHOOSE formula
Type '=CHOOSE(' followed by the index number (or cell reference) and the list of values separated by commas.
Close the function and press Enter
Add a closing parenthesis ')' and press Enter to execute the function and display the selected value.
=CHOOSE(index_num, value1, [value2], ...)The CHOOSE function will return a #VALUE! error.