Understanding Lookup and Reference Functions
Lookup and reference functions help you use your own worksheet tables as sources of information to be used elsewhere in formulas. You can use three primary functions to look up information stored in a list or a table or to manipulate references: LOOKUP, VLOOKUP, and HLOOKUP. Some powerful lookup and reference functions in addition to these three are available; we describe many of them in the following sections. You’ll find a list of all these functions by clicking the Lookup & Reference button on the Formulas tab on the Ribbon.
Lookup & Reference
Using Selected Lookup and Reference Functions
VLOOKUP and ...
Get Microsoft® Office Excel® 2007 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.
