Match & Index formula

SYNTAX: =MATCH(search_key, range, [search_type])

search_key - The value to search for. For example '42', 'Cats' or 'I24'.

range - The one-dimensional array to be searched.

search_type - [optional] - The search method. 1 (default) finds the largest value less than or equal to search_key when range is sorted in ascending order. 0 finds the exact value when range is unsorted. -1 finds the smallest value greater than or equal to search_key when range is sorted in descending order.

SYNTAX: =INDEX(reference, [row], [column])

reference - The array of cells to be offset into.

row - [optional] - The number of offset rows.

column - [optional] - The number of offset columns.