Get a value from a list.
CHOOSE Function can help you to get a value from a list based on its position. In simple words, you can call a value from a list by specifying the position of that value.
For example, if you have created a list of months (Jan to Dec) and if you mentioned position 5 it will return “May” in a result.
In above example, I have used CHOOSE Function with an option button to select the type of the service to calculate the shipping cost.
- index_num A number for specifying the position of the value in the list.
- value1 A range of cells or an input value from which you can choose.
- [value2] A range of cells or an input value from which you can choose.
More Information on Excel CHOOSE Function
- It can handle up to 254 values.
- You can refer to a cell or you can also insert values directly in the function.
In the below example, I am using CHOOSE Function with a drop-down list to calculate four(sum, average, max, and mix) different things. I have used below formula to calculate the all four things with CHOOSE Function.
I have created a small table with the name of all four calculations which I want and inserted a serial number to each in the corresponding cell.
After that, I have created a drop down list for all four calculations.
Now, to get index number in choose function from that small table I have created a lookup formula which will return serial number as per the value selected in drop down list.
And, instead of values, I have used four formulas for 4 different calculation. Whenever you select calculation type with drop down list it will change the calculation.
To learn more about Excel CHOOSE Function you can check Microsoft’s Help Section. And, if you have a unique idea to use the choose function, I would love to hear from you.