EDUCBA

EDUCBA

MENUMENU
  • Free Tutorials
  • Certification Courses
  • 120+ Courses All in One Bundle
  • Login
Home Excel Excel Resources Lookup & Reference Functions in Excel CHOOSE Function 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 Function in Excel

By Madhuri ThakurMadhuri Thakur

CHOOSE FUNCTION IN EXCEL

Excel CHOOSE Function

Choose function in excel simply returns a value from the selected list or array from any specific position. In a simple language, we choose function returns a value based on the given position from the selected available list of values. This function can be used in Excel worksheets or as VBA functions as well.

Formula:

Below is the CHOOSE Formula in Excel :

CHOOSE Formula in Excel

The CHOOSE formula has the following arguments:

Start Your Free Excel Course

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

  • Index_num = The position of a value for which we are looking for. It will always be a number between 1 and 254.
  • Value 1 = The first value/list from which to choose.
  • Value 2[optional] = The second value/list from which to choose.

In choose function, the Values parameter can be the cell references or the cell range. If Index_num is 1, then it will return Value 1.

Explanation of CHOOSE Function in excel

When we are looking for a value corresponding to the index number or applying the Vlookup function, we realized that we have to pick the data from the left side as the Vlookup function works on the right side of the lookup value.

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,813 ratings)

These problems can be solved by using the CHOOSE function in excel. Here we will discuss some examples for solving the above problems.

How to Use CHOOSE Function in Excel?

Let’s take a few CHOOSE functions in excel examples before using the Choose function workbook:

You can download this CHOOSE function Excel Template here – CHOOSE function Excel Template

Example #1

Let suppose; We have ranks from 1 to 4 and fruits Orange, Apple, Water Melon, and Banana. Now in the result, we want for rank 1, it should be Orange, rank 2, it should be Apple, and so on.

For this problem, we will use the choose function.

  • Click on the Formulas tab.

CHOOSE Example 1

  • Then click on lookup and reference and select CHOOSE Function.

CHOOSE Example 1-1

  • In cell B3, we wrote =choose then bracket open and click on insert function. It will open a function arguments dialog box as per the below screenshot.

CHOOSE Example 1-2

  • In Index_num – select A3 cell for which we are looking value.

CHOOSE Example 1-3

  • In Value 1 – Pass First list value, i.e. Fruit name Orange. It automatically takes the parameter as text in double-quotes.

CHOOSE Example 1-4

  • In Value 2 – Pass Second fruit name Apple.

CHOOSE Example 1- 5

  • In Value 3 – Pass Third fruit name Water Melon.

CHOOSE Example 1-6

  • In Value 4 – Pass Fourth fruit name Banana.

CHOOSE Example 1- 7

  • Click on ok.

CHOOSE function in excel 1-8

It will give the below result:

CHOOSE function in excel 1-9

Drag & drop the value from B3 to B6, and it will produce the below results:

CHOOSE function in excel 1-10

Example #2

Suppose you have the below list and you want to pick value to exist on 3rd position from the below list:

CHoose Function1

Now, you can use the formula =CHOOSE(3, A11, A12, A13, A14, A15, A16, A17)

CHoose Function2

The result is 43.

CHoose Function3

Example #3

We also can pass the range in place of values. Please see the below example:

Choose Function Example 3

=CHOOSE(3, A22: A24, B22: B24, C22: C24) – we have taken the first argument as 3 because we want to see the total of salary, which is the 3rd column in the above data. The above data is company employee data. Now we want to see the sum of the salary given by the company. Here we will use choose function with the sum function.

CHoose Example 3-1

The result is 56000.

CHoose Example 3-2

3rd index_num will choose the value from the 3rd range. If we pass 2nd as index_num, then it will choose the value from the 2nd range.

Example #4

We are taking an example of an XYZ company employee.

choose example 4

In the above example, we want to pick the Emp_id corresponding to the Emp_name. Here we will apply the Vlookup function along with CHOOSE function. Syntax is:

=VLOOKUP(G30, CHOOSE({1, 2,3, 4}, $B$30:$B$35, $C$30:$C$35, $D$30:$D$35, $A$30:$A$35), 4, FALSE)

choose example 4-1

Here we are passing an array at the place of the first argument in CHOOSE function. Index 1 indicates Column B, Index 2 indicates Column C, Index 3 indicates Column D, and Index 4 indicates Column A.

The result is 1014:

choose example 4-2

This method is also called the Left lookup formula with Lookup Function.

Recommended Articles

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

  1. FV Function in Excel
  2. YIELD Excel Function
  3. Logical Functions in Excel
  4. Write Formula in Excel
Popular Course in this category
Excel Training (23 Courses, 9+ Projects)
  23 Online Courses |  9 Hands-on Projects |  110+ Hours |  Verifiable Certificate of Completion
4.9
Price

View Course

Related Courses

Excel Advanced Training (16 Courses, 23+ Projects)4.9
2 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 function Excel Template

EDUCBA

Download CHOOSE function Excel Template

EDUCBA

डाउनलोड CHOOSE function 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