# 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: 