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|1 Comment

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.

One Comment

  1. Jignesh February 17, 2018 at 5:42 PM - Reply

    If i have more than 28 data from where i have to choose then i got error message…
    so what i have to do?

Leave A Comment


Related pages


replace excel formulalookup function excelvba excel graphxml to xlsx convertervlookup example between two sheetsmacro formula excelexcel macro open worksheethow to create drop down list in excel 2007excel macro write to cellvbyesnocancelsql vba excelcrlf vbaremove duplicate entries from excelexcel vba saveas fileformatexcel 2003 vba tutorialmsgbox inputexcel macro functionshow to unhide cells in excel 2010vlookup excel functionvba practice projectsexcel macro for beginnersoffset vba excelvba sort range3d clustered column chartexcel sorting formulacheckbox vba excelvb6 delete fileobject properties vbadelete row in vbabcg interview questionsvba reference3d bubble chart excelexcel chart title from cellvba excel xmlnested if excel 2007joining cells in excelhow to count duplicates in excelkpi dashboard examples excelvba autofilterfree capacity planning template excelvba box inputsql database for beginnersexcel vba userform frameexcel vba sortshow developer tab excel 2010vba for powerpointhow to use vlookup 2010scrum excel templatetrim excel functionsales dashboard exampleswhat is meant by vlookup in excelunprotect excel sheet without password 2007debug.print vbavlookup explanationhighlight duplicates excelexcel vba active worksheetarrange ascending order in excelthe tutorial on excel macros vba pdfvba find last row with dataproject charter pptexport from excel to access vbaadd the developer tab to the ribbonexcel macro end of columnadvanced functions of excelcreating macro in excel 2007vba beginners tutorialvba countifremove duplicate records exceltcl in sql servergoto in excel vbasql update from excelmonthly one on one meeting templatevba callvlookup examples 2010excel vba referencevba activexsave excel file vbaunhide multiple rows in excelvba select sheet