How to use the CHOOSE function in Excel

Aug 13, 2023

Learn how to use the CHOOSE function in Microsoft Excel. This tutorial demonstrates how to use Excel CHOOSE with an easy to follow example and takes you step-by-step through the different options when entering your formula.

CHOOSE Function (and sample data):
https://www.techonthenet.com/excel/fo…

Excel Tutorials:
https://www.techonthenet.com/excel/in…

Don’t forget to subscribe to our channel for more great Excel tutorials!

Visit us at: https://www.techonthenet.com
or follow us on:

Facebook: https://www.facebook.com/techonthenetcom
Twitter: https://twitter.com/tech_on_the_net
Pinterest: https://www.pinterest.com/techonthene…

Content

0.02 -> The CHOOSE function is another useful Lookup function in Excel

4.94 -> It allows you to return the value from a list of values based on its position in the list

10.34 -> To illustrate how the CHOOSE function works, let's look at an example

14.74 -> Here we have a column of data that lists our favorite website

18.58 -> Let's use the CHOOSE function to return a value from this list at a given position

23.3 -> To get started, let's begin by entering the CHOOSE command

27.02 -> As you can see, the CHOOSE function takes a number of parameters

31 -> The first parameter you must enter is the position number in the list of values that you wish to return

37.42 -> The first position in the list is 1, the second position in the list is 2, and so on

43.32 -> In this example, let's enter 1 to return the value that is first in the list of values

49.64 -> Next, we must provide the values that are included in your list

53.82 -> There must be at least one value in the list

57.44 -> and the function can accept up to 29 values in total

60.84 -> Since we want to include the 4 values in column A of our list

64.52 -> we will enter A2 as the second parameter

67.08 -> A3 as the third parameter

69.92 -> A4 as the fourth parameter

72.2 -> and A5 as the fifth parameter

74.8 -> Now that we have entered all of the parameters for the CHOOSE function

78.22 -> let's complete the command to look at our result

80.66 -> You should see the value "TechOnTheNet.com" appear in cell B2

85.22 -> This is the first value from our list of favorite websites

89.26 -> This completes our example of how to use Excel's CHOOSE function

93.6 -> If you would like to see more CHOOSE examples

95.92 -> or would like to download the sample data we used for this tutorial

99.46 -> please visit our website at TechOnTheNet.com

102.78 -> If you found our tutorial helpful, please leave a like on this video

106.94 -> and don't forget to subscribe to our YouTube channel for more great Excel tutorials

Source: https://www.youtube.com/watch?v=cS72DHzhvdA