How to use less than or greater than MATCH

We can use the INDEX function to designate a cell range (array) from which we want to retrieve data and, at the same time, use the MATCH function to specify the address of a cell in that cell range (array), i.e., row and column.   The MATCH function returns the relative position of the item in the range, either a row or a column. The relative position is returned in the form of an integer number, such as 1, 2,