CHOOSE Function in Excel – Formula Explained with Examples

Home/Excel Formulas/CHOOSE Function in Excel – Formula Explained with Examples

Choose Function: Explained with Examples

Choose function helps us to select a particular value from list of values. Or selecting particular cell or range from a range.

PREMIUM TEMPLATES LIMITED TIME OFFER

ON SALE80% OFF

50+ Project Management Templates Pack
Excel PowerPoint Word

Advanced Project Plan & Portfolio Template
Excel Template

Business Presentations Templates Pack
PowerPoint Slides

20+ Excel Project Management Pack
Excel Templates

20+ PowerPoint Project Management Pack
PowerPoint Templates

10+ MS Word Project Management Pack
Word Templates


For example, we may have some data in a range. And we wants to get a data from based on another selection. This type of functionality can be achieved with CHOOSE formula in Excel.

What is the use of CHOOSE function?

CHOOSE Function in Excel returns a value from a list of values based on a given index position.

What is the syntax of CHOOSE function?

CHOOSE Function in Excel- Syntax

CHOOSE( position, value1,

[value2], …).

position: index position number in the list of values to be returned.
value1, [value2], …: List of values to choose.

Note: The number of list item should be between 1 to 29. so you index position will be any number between 1 to 29.

CHOOSE Function in Excel – Examples

CHOOSE Function in Excel- Example

Example 1: Choose function returns 1001 as output.

=CHOOSE(1,A4,A5,A6,A7) formula choose the first (1) value from the list (A4,A5,A6,A7) and returns its value 1001 as output.

Example 2: Choose function returns “second” as output.

=CHOOSE(2,”first”,”second”,”third”) formula choose the second (2) value from the list (“first”,”second”,”third”) and returns its value second as output.

Example 3: Choose function returns 1025 as output.

=CHOOSE(4,A4,A5,A6,A7) formula choose the fourth (4) value from the list (A4,A5,A6,A7) and returns its value 1025 as output.

Example 4: Choose function returns 1008 as output.

=CHOOSE(2,A4,A5,A6,A7) formula choose the second (2) value from the list (A4,A5,A6,A7) and returns its value 1008 as output.

VBA example on CHOOSE function

CHOOSE function is also available in VBA, following is the example code:

Dim sOutout As String
sOutout =Choose(2, “First”, “Second”, “Third”)

Output: Second

This choose function(Choose(2, “First”, “Second”, “Third”)) in VBA, chooses the second (2) value from the list (“First”, “Second”, “Third”) and returns “second” as output.

Conclusion:

Choose function is helpful to extract a value from the list of values. Some times helps to alternative to LOOKUP formulas. CHOOSE formula will be used with the cobination of MATCH, INDEX, OFFSET to lookup a value which is not possible with VLOOKUP and HLOOKUP.

Reference:

Please refer the below article for more Lookup & Reference Excel functions.
Lookup & Reference Excel Formulas

Please refer the below article for more Excel Functions.
Excel Formulas | Home



Related Resource External VBA Reference
Excel VBA Reference Project Management Reference
VBA Reference:
Excel Reference:
By |February 25th, 2013|Excel Formulas|0 Comments

About the Author:

Excel VBA Developer having around 8 years of experience in using Excel and VBA for automating the daily tasks, reports generation and dashboards preparation. Valli is sharing to helps us automating daily tasks.

Leave A Comment


Related pages


excel duplicate cellsinstr function in vbavlookup shortcuthow to drop down list in excel 2007project planning worksheet templatevlookup functionsvba iconvba excel pivot tablewith selection vbafree excel userform templatesvisual basic editor in excel 2007sql interview questions and answers pdfhlookup examplevba vbyesnocancelvba as integerupdate sql database from excelhow to create a pie chart in excel 2007excel programming samplesexcel 2010 unprotect workbook without passwordcombine multiple cells in excelusing if statements in excelloop in macro excelminutes template exceladvanced filter macrohow do i unhide a row in excelisna excel 2010vba data validation listexcel vba status bar messagehow to use vlookup in excel 2010 step by stephow to program macros in excelunlock worksheetddl dml dcl tcl commandsexcel vba ado recordsetvba saveexcel 2007 advanced tutorialdashboard reporting with excel 2010remove duplicates in exceladodb connection providersas sql examplesadd a developer tab to the ribbonbuilding construction estimate spreadsheet excel downloadproject portfolio management template excelsas do until loopread file vbadrop down boxes in excel 2007excel auto row heightvba select a worksheetvlookup easy exampleshortcut for hide in excelvlookup definition wikipediaexcel vba create sheetiserror excel 2013hlookup in excel examplemerge excel rowsfree pnrowhat is hlookup in excel used forexample of hlookupwhat are dml statementsexcel insert row vbavba private functionhow to use the vlookup function in excel 2010how to remove duplicates in excel 2013userforms excelvlookup rulesdemographic chart templateexcel isequaladvanced filtering excel 2013count if excel functionsumif tutorialproject vbadynamic dashboard in excel