How to Use the CHOOSE Function in Excel – Tutorial

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:

1. In the first example, we’ll explain the basic use of the CHOOSE function.
2. 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.