Welcome to the Treehouse Community

Want to collaborate on code errors? Have bugs you need feedback on? Looking for an extra set of eyes on your latest project? Get support with fellow developers, designers, and programmers of all backgrounds and skill levels here with the Treehouse Community!

Looking to learn something new?

Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and join thousands of Treehouse students and alumni in the community today.

Start your free trial

Data Analysis Spreadsheet Basics Spreadsheet Functions & Shortcuts The CHOOSE Function

I watched this video twice and I still don't get what the usefulness of CHOOSE is...

What exactly is he accomplishing by indexing these values?

1 Answer

The way he is using the CHOOSE function, it is basically allowing him to quickly substitute in one of the listed values so he can do a hypothetical cost analysis. It may help to think of the values as items in a drop down list, but instead of selecting one of the items by clicking it, you are entering the index number for the item. The scenario he is using is probably not very realistic, as a real-world example would probably be more involved and have ranges of values that you are choosing from, and then they are probably being piped into another formula like SUM. Personally, I've never used the CHOOSE function, but I could see where it may have its uses.