The MATCH function returns the position of a value (in a list, table, database). And, the INDEX-MATCH functions used together make extracting data from a table a breeze.

Let’s see how you can reverse a list in Excel by using the INDEX function. Here, we have a sample list containing the names of the persons and we want to reverse this list.

Using the INDEX Function. Select the cell where you want the result of the INDEX function to appear. Enter the formula =INDEX(array, row_num, [column_num]).

Again in cell I2, edit the formula by adding the Index function, which uses the information returned by the Match function to fetch the company name from the 33rd row in column A. The completed ...