FINDEX(value, list)

The FINDEX function searches the list and returns the position of value in the list. If list does not contain value, #VALUE is returned.

The list can contain numbers, text, cell addresses, ranges, and cell names. The list can be in any order (which contrasts with FIND).

For example,

FINDEX(15, 18, 15, 10, 3, 35, 12)

returns 2, the second position in the list.

If the list you want to search is a range that contains several rows and several columns, Ability searches the range from left to right and top to bottom.

The FINDEX function is similar to the LOOKUP function (see LOOKUPEX), except that LOOKUPEX returns an actual value, rather than the position of the value in a list.

The INDEX function (see INDEX) is also similar to the FINDEX function, except that with INDEX you enter the position rather than a test value in a list.

See also:

Other lookup functions