How to Use Choose Formula in Excel?
This is powerful Excel CHOOSE formula that returns a value from a list using a given position or index. For example, CHOOSE(2,"XXL","XL","L") returns "S", since XL is the 2nd value listed after the index number. The values provided to CHOOSE can include references. The formula for CHOOSE FUNCTION IS :- =CHOOSE (index_num, value1, [value2],[value3],[value4], ...)