CHOOSE
The CHOOSE() function is one of my favorite functions! It quickly allows me to “choose” from a defined list of values when aspecific events occur.
CHOOSE Formula
=CHOOSE(Index Number, Value1, [Value2], [Value3],…)
The CHOOSE function allows you to choose from a list of values using the index number as the list position
Example
CHOOSE(4, “Cactus”, 4, $B$3, “4th Quarter”) will return “4th Quarter” because the 4th value in the list is “4th Quarter”. The values provided to CHOOSE can include references, notice the cell reference $B$3 in the 3rd position of our list.
As with all functions in Excel, the versatility of this function is only limited to your imagination and use of nested functions.
NOTE:
The index number in the formula needs to be a whole number greater than or equal to 1. If the number is greater than the number of list items, the formula will return a #VALUE.
The index number in the formula needs to be a whole number greater than or equal to 1. If the number is greater than the number of list items, the formula will return a #VALUE.
Additional Examples
Easy Calendar Quarters
Assuming that you have a date in cell A1
=CHOOSE(Month($A$1), “Q1”, “Q1”, “Q1”, “Q2”, “Q2”, “Q2”, “Q3”, “Q3”, “Q3”, “Q4”, “Q4”, “Q4”)
I find that this is a fast way to get a calendar quarter when dealing with dates