Excel CHOOSE Function

HomeExcel FunctionsExcel CHOOSE Function (Example + Sample File)

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:

Syntax

CHOOSE(index_num,value1,value2,…)

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.

Notes

  • You can refer to a cell or you can also insert values directly in the function.

Example

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.

Related

So, we have used the below formula to calculate all four things:

=CHOOSE(VLOOKUP(K2,Q1:R4,2,FALSE),SUM(O2:O9),AVERAGE(O2:O9),MAX(O2:O9),MIN(O2:O9))

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.

Related functions

This tutorial is the part of our Excel Functions with Examples (Function Guide) and below are some of the related functions:

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 find him online, tweeting about Excel, on a running track, or sometimes hiking up a mountain.