The INDEX function returns a value or the reference to a value from within a table or range. Among other things it can look up two or more criteria in columns and rows. The INDEX function can also return a specific value in a two-dimensional range.
The INDEX MATCH formula is the combination of two functions in Excel.
INDEXamtsSMALLIFids idROWids - ROWINDEXids11 1 H6. For example use INDEX and MATCH in Excel to perform a two-way-lookup. The INDEX and MATCH Function in Excel can be used in combination to Lookup values much faster than VLOOKUP. 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.