Lookup & Reference Functions

This page lists the built-in Excel Lookup and Reference Functions.

These functions are provided by Excel, to help you to work with arrays of data. They include functions that return the location of a given address or value, and functions to look up given values.

The functions listed below have been grouped into categories, to help you to find the function you need. Each function page provides a full description of the function, with examples of use and common errors.

Database Functions

The Excel Database Functions have been provided to help you to work with a database - ie. a large number of data records, stored in Excel.

The database functions perform basic operations, such as sum, average, count, etc, but they include criteria arguments, which enable you to only include some of the records from your database in the calculation. Other records in the database are ignored.

The current, built-in Excel Database Functions are listed in the table below. Select one of function names, to go to a full description of the function with examples of use.