How to use choose formula in excel || by Quicklink
The Excel CHOOSE function returns a value from a list using a given position or index. For example, =CHOOSE(2,"Yellow","Red","orange") returns "blue", since blue is the 2nd value listed after the index number. The values provided to CHOOSE can include references.