EDUCBA Logo

EDUCBA

MENUMENU
  • Explore
    • EDUCBA Pro
    • PRO Bundles
    • Featured Skills
    • New & Trending
    • Fresh Entries
    • Finance
    • Data Science
    • Programming and Dev
    • Excel
    • Marketing
    • HR
    • PDP
    • VFX and Design
    • Project Management
    • Exam Prep
    • All Courses
  • Blog
  • Enterprise
  • Free Courses
  • Log in
  • Sign Up
Home Excel Excel Resources Lookup & Reference Functions in Excel CHOOSE Function in Excel
 

CHOOSE Function in Excel

Madhuri Thakur
Article byMadhuri Thakur

Updated May 3, 2023

CHOOSE FUNCTION IN EXCEL

 

 

Excel CHOOSE Function

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

Watch our Demo Courses and Videos

Valuation, Hadoop, Excel, Mobile Apps, Web Development & many more.

Formula:

Below is the CHOOSE Formula in Excel :

CHOOSE Formula in Excel

The CHOOSE formula has the following arguments:

  • Index_num = The position of a value for which we are looking. 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 looking for a value corresponding to the index number or applying the Vlookup function, we realize that we have to pick the data from the left side as the Vlookup function works on the right side of the lookup value. Utilizing Excel’s CHOOSE function will allow you to tackle these issues. Here we will discuss some examples for solving the above problems.

How to Use CHOOSE Function in Excel?

Let’sLet’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

Exat’s suppose; We have ranks from 1 to 4 and fruits Orange, Apple, Water Melon, and Banana. Now in the result, we want to 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 the Second fruit named Apple.

CHOOSE Example 1- 5

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

CHOOSE Example 1-6

  • In Value 4 – Pass the Fourth fruit name the 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 a value to exist on the 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 salary, which is the 3rd column in the above data. The above data is company employee data. Now we want to know the sum of the salary given by the company. Here we will use the 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 pass an array at the place of the first argument in the 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 the Formula in Excel

Primary Sidebar

Footer

Follow us!
  • EDUCBA FacebookEDUCBA TwitterEDUCBA LinkedINEDUCBA Instagram
  • EDUCBA YoutubeEDUCBA CourseraEDUCBA Udemy
APPS
EDUCBA Android AppEDUCBA iOS App
Blog
  • Blog
  • Free Tutorials
  • About us
  • Contact us
  • Log in
Courses
  • Enterprise Solutions
  • Free Courses
  • Explore Programs
  • All Courses
  • All in One Bundles
  • Sign up
Email
  • [email protected]

ISO 10004:2018 & ISO 9001:2015 Certified

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

EDUCBA

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

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more

EDUCBA

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

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

By continuing above step, you agree to our Terms of Use and Privacy Policy.
*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA

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

EDUCBA

Download CHOOSE function Excel Template

EDUCBA Login

Forgot Password?

EDUCBA

Download CHOOSE function Excel Template

EDUCBA

डाउनलोड CHOOSE function Excel Template

🚀 Limited Time Offer! - 🎁 ENROLL NOW