When you work with data in spreadsheets, it’s often useful to return a value from a given position within a range of data. Fortunately, you don’t have to do this manually. Excel offers an easy function to do exactly this. Let’s learn how to use CHOOSE in Microsoft Excel.
How to Use CHOOSE in Excel
Imagine that you have a list of data contained in a range. For example, the names of eight American states are listed in cells A1:A8. You want to quickly pull the sixth name (value) from this list. Of course, for a simple example like this, it’s easy to simply pick out cell A6 as the sixth value.
But imagine if you needed the 131st value in the range A39:A184. That’s not as easy to identify at a glance, especially as part of a larger formula.
This is where the CHOOSE function comes in. CHOOSE evaluates cells and returns the value found in a given position.
To use CHOOSE in our example, click into any blank cell in your workbook. Then, type an = sign, telling Excel that you’re inputting a formula. Then, type CHOOSE(. So far, your formula is:
=CHOOSE(
Since we want to find the sixth value in the list, type 6, followed by a comma.
Then, you’ll need to list each of the cells to evaluate, completing your formula as:
=CHOOSE(6,A1,A2,A3,A4,A5,A6,A7,A8)
Hit Enter on your keyboard, and the sixth value will display in the cell:
Washington
As you can see, the CHOOSE formula is an easy way to evaluate lists of data in Microsoft Excel. The inputs are quite simple, and the formula works well with large volumes of data.
Try it out next time you need to pull a given value from a certain position in a list or range of data.