Utilize the CHOOSE function to select from a list
Syntax: CHOOSE(index_num, value1, [value2], …)
Step 1: Define the index_num (position of the desired value in the list).
Step 2: List the values to choose from.
Step 3: Enter the formula in a cell and press Enter.
For all things Strategy, Management Theories, and Business Frameworks, please visit https://www.stratrix.com