• Skip to main content
  • Skip to header right navigation
  • Skip to site footer

Excelypedia

The Excel Encyclopedia of The Internet

  • Tutorials
  • Functions
  • Formulas
  • Templates

CHOOSE in Excel

January 24, 2022 by Andrew Childress
Choose Excel

Working with data in spreadsheets it's often useful to return a value from a given position within a range of data. Here's how to use CHOOSE in Excel.

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(

Choose Excel

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)

Choose in Excel

Hit Enter on your keyboard, and the sixth value will display in the cell:

Washington

Choose function in Excel

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.

Category: Excel FunctionsTag: Excel, How To, Instructions, Tutorial

About Andrew Childress

Previous Post: « Custom tab color Excel Tab Color in Excel
Next Post: Constants in Excel How to use constants in Excel »

Sidebar

Recent Posts

  • Format Cell Alignment in Excel
  • Default Width in Excel
  • Translate in Excel
  • Switch Windows in Excel
  • EXACT in Excel

Categories

  • Basics
  • Examples
  • Excel Formulas
  • Excel Functions
  • Excel Shortcuts
  • Excel Templates
  • Excel Tutorials
  • Uncategorized

Excelypedia

Master Excel to add a highly valuable asset to your employability portfolio. Learn how to analyze data in Excel.

  • Facebook
  • Twitter
  • Instagram
  • LinkedIn
  • YouTube

Learn

  • Functions
  • Formulas
  • Shortcuts

Legal

  • Privacy Policy
  • Cookie Policy
  • Terms & Conditions

Help

  • FAQ
  • Contact Us

Copyright © 2023 · Excelypedia · All Rights Reserved

Back to top