What is EXCEL CHOOSE FUNCTION
The Excel CHOOSE Function is listed under Microsoft Excel's Lookup Functions category. It returns a value from the list of values based on the position number specified. In simple words, it looks for a value from a list based on its position and returns it in the result.
How to use it
To learn how to use the CHOOSE function in Excel, you need to understand its syntax and arguments:
- 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.
- You can refer to a cell or you can also insert values directly in the function.
To master CHOOSE function we need to try it out in an example, so make sure to check out the below one:
In the below example, we have used CHOOSE function with a drop-down list to calculate four(sum, average, max, and mix) different things.
- How to Create a Dependent Drop Down List in Excel
- How to Create a Dynamic Drop Down List in Excel
- How to Create a Data Validation with Date Range
So, we have used the below formula to calculate all four things:
We have this small table with the name of all four calculations which we want and a serial number to each in the corresponding cell.
After that, we have a drop-down list for all four calculations.
Now, to get index number in the choose function from that small table we have a lookup formula which will returns serial number as per the value selected from the drop-down list.
And instead of values, we have used four formulas for 4 different calculations.
This tutorial is the part of our Excel Functions with Examples (Function Guide) and below are some of the related functions:
- EXCEL ADDRESS Function
- EXCEL AREAS Function
- EXCEL COLUMN Function
- EXCEL COLUMNS Function
- EXCEL FORMULATEXT Function
- EXCEL HLOOKUP Function
- EXCEL HYPERLINK Function
- EXCEL INDEX Function
- EXCEL INDIRECT Function
- EXCEL LOOKUP Function
- EXCEL MATCH Function
- EXCEL OFFSET Function
- EXCEL ROW Function
- EXCEL ROWS Function
- EXCEL TRANSPOSE Function
- EXCEL VLOOKUP Function
About the Author
Puneet is using Excel since his college days. He helped thousands of people to understand the power of the spreadsheets and learn Microsoft Excel. You can ﬁnd him online, tweeting about Excel, on a running track, or sometimes hiking up a mountain.