Microsoft® Excel® 2010 Formulas & Functions Inside Out

Chapter 10. Lookup and Reference Functions

• ADDRESS()

• AREAS()

• CHOOSE()

• COLUMN()

• COLUMNS()

• GETPIVOTDATA()

• HLOOKUP()

• HYPERLINK()

• INDEX()

• INDIRECT()

• LOOKUP()

• MATCH()

• OFFSET()

• ROW()

• ROWS()

• RTD()

• TRANSPOSE()

• VLOOKUP()

The lookup and reference functions or array functions in Microsoft Excel (see Table 10-1) are the some of the best Excel has to offer. The reference functions VLOOKUP(), LOOKUP(), and HLOOKUP(), as well as INDEX() and MATCH(), provide an amazing array of tools for searching and finding information in a spreadsheet. In combination, they can be used to enhance the way you work.

Some functions return general information about cells (COLUMN(), ROW(), and ADDRESS()), and other functions return specific information (OFFSET(), COLUMNS(), and ROWS()). Initially ...