Lookup functions

The built-in functions listed in this section are known as the Lookup Functions. You use these functions to search for the location of specific information. These functions are most useful if you are working with tax tables or other kinds of spreadsheet tables that you want to use for looking up and referring to information.

Here is a complete list of lookup functions in Ability:

ADDRESS

AREAS

CHOOSE

COLUMN

COLUMNS

FIND

FINDEX

HLOOKUP

INDEX

INDIRECT

LOOKUP

LOOKUPEX

OFFSET

ROW

ROWS

VLOOKUP

See also:

Other functions