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

LIMITED TIME OFFER
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 2007 stacked bar chartmacro learning in excelhow to combine tabs in excelshow userform vbahow to delete activexexcel vba objectsvbscript excel saveasexcel exercise for job interviewmacro enabled excel filemacro open excel filedata entry form in excel 2007close userform excel vbavba select case exampleexcel 2010 hlookupcreate userform excelexcel macro merge cellsvlookup practice sheetsclose excel in vbaexcel delete empty cellsexcel vba report examplemacros and vbalistbox propertieshow to create macros in excel 2007index formula excel 2007vba datediffms excel test questions and answershow to find duplicates in excel using pivot tableoutlook macro examplesswitch statement vbavba selection.sortsql commands with syntax and examples pdfinsert macro button excelpivot table explainedvba color indexchart wizard in excel 2010controls vbaexcel vba select workbookexcel vba activeworkbook.saveasexcel insert tick boxproject plan gantt chart templateembedded chart in excelinteger function excelexcel how to insert rowmatch excel formulavb programming examplesexcel vba screen updatecreating checkboxes in excelhow to convert xlsx to xmlcharter template project managementvlookup na errorhow to write a query in excelchart wizard excel 2007gantt chart excel download freegetopenfilename excelexcel sales dashboard templatessas tutorial pptmaking dashboards in excelexcel macro open excel fileexcel 2007 vlookup tutorialexcel 2010 nested ifvlookup excel 2007 tutorialwhat is a hyperlink in excelwhat does sub mean in vbaexcel formula columnvba protect sheetexcel insert tick boxunderstanding excel macrosunprotect an excel fileclose file vbamerge excel worksheets into one master worksheetusing worksheet functions in vbahow to create pivot table in excel 2007delete duplicates on excelfinding duplicates in excel 2007vba save workbookexcel rows vbavba set column widthadding a checkbox in excelexcel duplicate linesexcel chart worksheetno of rows and columns in ms excel