excel training program - Choose

The choose function return the value of a list of values based on its position. For example,

=CHOOSE(1, Don, attended, excel, advanced) would return "Don"
=CHOOSE(2, Don, attended, excel, advanced) would return "attended"
=CHOOSE(3, Don, attended, excel, advanced) would return "excel"
=CHOOSE(4, Don, attended, excel, advanced) would return "advanced"

hope that helps

Tracy