Special Edition Using® Microsoft® Office Excel 2003

Chapter 13. Lookup and Reference Functions

In this chapter

• Lookup and Reference Functions Overview

• CHOOSE

• HLOOKUP

• INDEX (Array Form)

• INDEX (Reference Form)

• Using the Lookup Wizard

• LOOKUP (Array Form)

• LOOKUP (Vector Form)

• OFFSET

• Auto Update Charts Using the OFFSET Function

• TRANSPOSE

• VLOOKUP

Lookup and Reference Functions Overview

Lookup and reference functions are probably some of the most frequently asked, “How do I?” questions of all functions. Because so many people use Excel to manage data stored in lists in some form or fashion, at times you’ll need to look up information associated with an item. For example, if you have several product names in a database and want to look up the associated inventory number for the product, you could do this several ways ...