EDUCBA

EDUCBA

MENUMENU
  • Free Tutorials
  • Certification Courses
  • 120+ Courses All in One Bundle
  • Login
Home Excel Excel Resources Lookup & Reference Functions in Excel CHOOSE Formula in Excel
Secondary Sidebar
Excel Functions
  • Lookup and Reference Functions in Excel
    • VLOOKUP Function in EXCEL
    • VLOOKUP True
    • VLOOKUP Error
    • How to Match Data in Excel
    • Excel Match Function
    • Excel Lookup Function
    • ROWS Function in Excel
    • Excel INDEX Function
    • VLOOKUP Table Array
    • Excel OFFSET Formula
    • VLOOKUP For Text
    • IF VLOOKUP Formula in Excel
    • Mixed Reference in Excel
    • CHOOSE Formula in Excel
    • Excel COLUMN to Number
    • Excel Alternatives to VLOOKUP
    • HLOOKUP Examples
    • Excel VLOOKUP From Another Sheet
    • VLOOKUP with Sum
    • Fixing VLOOKUP Errors
    • Excel ROW Function
    • HYPERLINK in Excel
    • Address Excel Function
    • Excel COLUMNS Function
    • Excel REPLACE Function
    • OFFSET Excel Function
    • Excel GETPIVOTDATA Function
    • MATCH Function in Excel
    • VLOOKUP Function in Excel
    • HLOOKUP Function in Excel
    • LOOKUP in Excel
    • CHOOSE Function in Excel
    • TRANSPOSE in Excel
    • COLUMN Function in Excel
    • INDIRECT Function in Excel
  • Excel Functions (12+)
  • Excel Tools (114+)
  • Financial Functions in Excel (17+)
  • Logical Functions in Excel (14+)
  • Maths Function in Excel (47+)
  • TEXT and String Functions in Excel (26+)
  • Date and Time Function in Excel (24+)
  • Statistical Functions in Excel (59+)
  • Information Functions in Excel (4+)
  • Excel Charts (56+)
  • Excel Tips (222+)
  • Workplace Productivity (4+)
  • Microsoft Office Tools (15+)
  • Excel Formula and Functions (22+)
  • MS Excel Shortcuts (4+)
Excel Functions Courses
  • Online EXCEL COURSE
  • Online EXCEL ADVANCED Training

CHOOSE Formula in Excel

By Madhuri ThakurMadhuri Thakur

CHOOSE Formula in Excel

Excel Choose Formula (Table of Contents)

  • CHOOSE Formula in Excel
  • How to Use CHOOSE Formula in Excel?

Introduction to CHOOSE Formula in Excel

MS Excel provides several VBA inbuilt functions; one of them is Choose Function, which is used to choose a value by position or index from the given list of values. The Index number can be a number between 1 to 254, and values also can be 1 to 254 values.

The syntax of Choose Function: Choose()

It will return a value. There are two parameters or arguments required in the Choose Function- Index number and values.

Start Your Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

CHOOSE Formula Example 1-1

How to Use CHOOSE Formula in Excel?

CHOOSE Formula in Excel is very simple and easy to use. Let us now see how to use the CHOOSE Formula in Excel with the help of some examples. These examples will surely help you with a clear understanding of the function.

All in One Excel VBA Bundle(120+ Courses, 30+ Projects)
Basic ExcelAdvanced ExcelVBA & MacrosExcel Dashboards
Pivot TablesStatistical FunctionsFinancial FunctionsCharts & Graphs
Price
View Courses
120+ Online Courses | 30+ Projects | 500+ Hours | Verifiable Certificates | Lifetime Access
4.9 (64,725 ratings)
You can download this CHOOSE Formula Excel Template here – CHOOSE Formula Excel Template

Excel CHOOSE Formula – Example #1

Let’s assume there are five colors ‘Red’, ’Blue’, ’Black’, ’Pink’ and ‘Green’.

CHOOSE Formula Example 1-2

Now, if a user wants to choose a color based on its position. So, how a user will be able to choose a color based on its position.

As the user wants to choose a color based on its position, where he needs to use the choose function. so write the below formula in cell B1.

CHOOSE Formula Example 1-3

Now it will ask for the index number and values from where the user wants to choose a value. Now let’s assume a user wants to choose the 3rd value so that the index number will be 3. It will ask for values, so the user has five colors from where he wants to choose the 3rd value.

CHOOSE Formula Example 1-4

Click on the Enter button.

CHOOSE Formula EXAMPLE 1-5

Summary of Example 1: As the user wants to choose the 3rd color from the given five colors ‘Red’, ’Blue’, ’Black’, ’Pink’ and ‘Green’. There is ‘Black’ in the 3rd position in the given order.

Same coming by the choose function. A user can change the value of the index number between 1 to 5. The result will come as per the index number is given in the function.

Excel CHOOSE Formula – Example #2

A user has staff details like the First Name, CITY, and Date of Retirement of their employee. Now the user wants to choose their city from the table.

So, how a user will be able to choose a city based on its position in the table.

Open MS Excel, go to sheet1, where the user wants to choose a city based on its position.

CHOOSE Formula Example 2-1

As the user wants to choose an employee city name based on its position in the table, where he needs to use the choose function. So, write the below formula in cell E2-

CHOOSE Formula Example 2-2

It will then ask for the index number and values from where the user wants to choose a value as the user wants to choose the city name for each employee available in the 2nd column of the table. So, the index number will be 2.

CHOOSE Formula Example 2-3

Now it will ask for values, so as a user, have some staff where everyone belongs to some city. Now he needs to select the range of name and city.

CHOOSE Formula Example 2-4

‘OR’

Just select the city range; that is also fine. This case index number will be 1 because there is only one value range selected: the city.

=CHOOSE (1, B4: B15)

For now, we are taking the first name of the employee and city name in the value. Now click on the enter button.

CHOOSE Formula Example 2-5

Just apply the same formula to the cell E5 to E15 by dragging the E4 formula.

Example 2-6

Summary of Example 2: As the user wants to choose his staff’s city name from the given staff data table. In a similar way, a user can choose the first name, city, or date of retirement of his/her employee.

Same coming by the choose function. A user can change the value of the index number between 1 to 3. The result will come as per the index number is given in the function.

Excel CHOOSE Formula – Example #3

A user has staff details like Employee Name, Home city, and Salary Monthly (Rs.) of their employees.

Example 3-1

Now the user wants to choose their random data from the employee details table so, how a user will be able to choose random data based on its random position in the table.

Open MS Excel, go to sheet2, where the user wants to choose random data based on its position.

As the user wants to choose employee random data based on its position in the table, where he needs to use the choose function with the RANDBETWEEN excel function. So, write the below formula in cell E2-

Example 3-2

Now it will ask for the index number and values from where the user wants to choose a value.

As the user wants to choose random employee data that is available in the employee table. So, he needs to use the RANDBETWEEN function.

Example 3-3

Now It will ask for values. So, just select all data range and give the RANDBETWEEN range 1 to 3.

=CHOOSE (RANDBETWEEN (1,3),A2:A13,B2:B13,C2:C13)

Example3-4

Now click on the enter button.

Example 3-5

Just apply the same formula to the cell E3 to E13 by dragging the E2 formula.

Example 3-6

Summary of Example 3: As the user wants to choose the random data of staff from the given staff data table. As we can see from the result, random data is coming from the staff details.

There is Employee name, Home city or Salary appearing in column E as random. It will change every time when the user changes any data in the table.

Things to Remember

  • The Index number can be a number between 1 to 254, and values also can be 1 to 254 values.
  • Index number always will be a number. It cannot exceed the total number of values given in the choose function. Otherwise, it will give an error #VALUE.
  • If the Index number is a fraction, then it will automatically delete the fraction part to the nearest integer number.

Recommended Articles

This has been a guide to CHOOSE Formula in Excel. Here we discuss How to use CHOOSE Formula in Excel along with practical examples and a downloadable excel template. You can also go through our other suggested articles –

  1. SUMPRODUCT Formula in Excel
  2. COUNTIF Formula in Excel
  3. CHOOSE Function in Excel
  4. Write Formula in Excel
Popular Course in this category
Excel Advanced Training (16 Courses, 23+ Projects)
  16 Online Courses |  23 Hands-on Projects |  140+ Hours |  Verifiable Certificate of Completion
4.8
Price

View Course

Related Courses

Excel Training (23 Courses, 9+ Projects)4.9
3 Shares
Share
Tweet
Share
Primary Sidebar
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Corporate Training
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Excel Charts
  • Excel Tips
  • All Tutorials
Certification Courses
  • All Courses
  • Excel VBA Course - All in One Bundle
  • VBA Course
  • Excel Data Analysis Course
  • Excel for Marketing Course
  • Excel for Finance Course
  • Excel for HR Training

ISO 10004:2018 & ISO 9001:2015 Certified

© 2022 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA Login

Forgot Password?

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

Download CHOOSE Formula Excel Template

EDUCBA

Download CHOOSE Formula Excel Template

EDUCBA

डाउनलोड CHOOSE Formula Excel Template

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more