The FIND function searches the list to find where the largest item that is less than or equal to value occurs in the list. The list can contain numbers, text, cell addresses, ranges, and cell names.
The list must be sorted in ascending order (as contrasted with the FINDEX function – see FINDEX).
For example,
FIND(19, 1, 15, 20, 30, 35, 40)
returns 2, the second position in the list, as 15 is the last value in the list that is less than or equal to the test value.
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 FIND function is similar to the LOOKUP function (see LOOKUP), except that LOOKUP returns an actual value, rather than the position of the value in a list.
The INDEX function (see INDEX) is also similar to the FIND function, except that with INDEX you enter the position rather than a test value in a list.
See also: