Chapter 13. Lookup and Reference Functions

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

Get Special Edition Using® Microsoft® Office Excel 2003 now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.