The INDEX function can handle arrays natively so the second INDEX is added only to catch the array created with the boolean logic operation and return the same array again to MATCH. Just think like this MATCH function is an undercover agent who finds the criminal and INDEX function is a cop who arrests that criminal afterward. To do this INDEX is configured with zero rows and one column.
Below is the syntax of the INDEX function.
Row_num the row number from which the value is to be fetched. The MATCH function searches for a specified item in a range of cells and then returns the relative position of that item in the range. This number is the number of the row in the data where the last name Jones is found. In the attached file I have a table with 9 different indexes now I need to organize the information for each one of them that is to say that the data that are registered in the rows cells A2A1964 appear in the corresponding columns K2S2 but it only works with the first index that is to say the data corresponding to column K.