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 Continue Reading