Excel Lookup and Reference Functions

Special

Excel Functions

2003

Special

Excel Functions

2007

Lesson 7: Excel Spreadsheets Lookup and Reference Functions (18)

In annex 7 you have found a description of all 18 Excel functions in the "LookUp and Reference" category. Below is the list of the 5 most useful ones. See more on the very powerful INDEX/MATCH Excel formulas in lesson 12 and in the three old lookup functions in lessons 17, 18 and 19: HLOOKUP function, LOOKUP fonction and VLOOKUP function.

Functions	What it Does
INDEX	Uses an index to choose a value from a reference or array (Powerful in INDEX/MATCH Formulas)
MATCH	Looks up values in a reference or array (Powerful in INDEX/MATCH Formulas)
INDIRECT	Returns a reference indicated by a text value
OFFSET	Returns a reference offset from a given reference
ADDRESS	Returns a reference as text to a single cell in a worksheet

IIn the downloadable tutorial on Excel functions and formulas you will find example of formulas using each of these functions and even many of them assembled in easy and powerful formulas.

Go to the next lesson:
Lesson 8: Excel Mathematical Functions

See the complete version of this lesson in
The Tutorial on Excel
Functions