We may be compensated for your purchase of any of the products featured on this page – it helps us keep the lights on :)
Excel tutorial on how to use the CHOOSE function in Excel. The CHOOSE function returns the value of an item in a list based on the order of its location when that list was added to the function.
In this tutorial, we’ll look at 2 examples of the CHOOSE function:
- In the first example, we’ll explain the basic use of the CHOOSE function.
- In the second example, we’ll combine the CHOOSE function with another formula. We’ll combine it with the AVERAGE function to help us find average weekly temperatures by week number.