Chapter 10. Lookup and Reference Functions

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 ...

Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.