Excel - CHOOSE function
If you have a list of values, Excel CHOOSE functions returns a certain value by the index number. For example, if you have the week days from Monday to Sunday, the 2nd one is Tuesday. Note: When using CHOOSE function, you cannot select a data range such as A2:A8, you have to select the values one by one, separated by comma. The formula is: =CHOOSE(D2,A2,A3,A4,A5,A6,A7,A8) You can manually enter values instead of cell positions. For example, the following formula returns "banana". =CHOOSE(2,"apple","banana","orange")