Microsoft Office Tutorials and References
In Depth Information
CHAPTER 9 Lookup and Reference Functions
9
CHAPTER
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, what if you have several
product names in a database and want to look up the associated ISBN number
for the product? You could do this several ways using Excel’s lookup functions.
You could, for example, use the VLOOKUP function or combine the INDEX and
MATCH functions to pinpoint the ISBN number.
The following functions will be discussed in this chapter.
ADDRESS
AREAS
CHOOSE
COLUMN
HLOOKUP
HYPERLINK
INDEX (Array Form)
INDEX (Reference Form)
INDIRECT
LOOKUP (Array Form)
LOOKUP (Vector Form)
MATCH
OFFSET
ROW
ROWS
TRANSPOSE
VLOOKUP
Search JabSto ::




Custom Search