Excel CHOOSE Function Tutorial

Excel's Lookup functions, which includes the CHOOSE function, are used to find and return data from a list or table based on a lookup value or index number. In the case of CHOOSE, it uses an index number to find and return a specific value from a correspo

spreadsheets.about.com