Advanced Decision Making using CHOOSE in Excel

Add to Favorites
Author: | Edits: don

How to make decisions in Excel without using an IF statement; here, we use the CHOOSE() function to make dynamic and advanced logical tests that eliminate the need for nested IF functions, in many cases.

The CHOOSE() function is a really helpful and powerful function that allows you to return a value or perform an action based on an index number that you supply the function. The cool thing is that you can return range references as well as text or number values - this allows you to make complex dynamic formulas.

This feature is also one of the building blocks for large complex Excel models and scenario analysis techniques because it allows you to build a worksheet that can completely change with the adjustment of a single cell.

I hope you find this tutorial helpful!)


Excel Function: CHOOSE()
Downloadable Files: Excel File

Question? Ask it in our Excel Forum


Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons 50+ Hours of Instruction 200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Similar Content on TeachExcel
Logical Comparison Operators in Excel - How to Compare Things
Tutorial: (Video tutorial's page: Compare Values in Excel - Beginner to Advanced) Logical compariso...
Make Professional Looking Rounded Buttons in Excel
Tutorial: How to make professional looking rounded buttons in Excel. This allows you to avoid using ...
Create and Manage Tables in Excel
Tutorial: Here, I'll show you everything you need to know to get started using tables in Excel; how...
What is a UserForm in Excel?
Tutorial: A UserForm is basically a pop-up window that you can use to create a custom interface for ...
Confirm User Input using VBA and Macros in Excel
Tutorial: View the Full VBA/Macro Course How to have a user confirm their input using vba - this fe...
Using Parentheses in Excel
Tutorial: How to use parentheses in Excel in order to create more powerful formulas and functions. S...
Tutorial Details
Excel Function: CHOOSE()
Downloadable Files: Excel File
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course