Chapter 13. Lookup and Reference Functions
In this chapter
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 ...