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.
Zrób to z SISelect 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.