This is not possible when you are using VLOOKUP or HLOOKUP functions. It can also be used when the result column is on the left side of the array. =INDEX(return the value/text, MATCH(from the row position of this value/text)) =INDEX(array, MATCH(lookup_value, lookup_array, ) The general syntax for the Index Match function is – The capacity to search for and extract data based on a variety of criteria is crucial in applications such as financial modeling, data analysis, and other fields. Index Match with multiple criteria enables users to rapidly and effectively search and extract specific data from huge and complicated datasets by employing several criteria, such as matching values in distinct columns. One of the advantages of using Index Match is that you can search for a value that matches multiple criteria. It searches the row position of a value/text in one column (using the MATCH function) and returns the value/text in the same row position from another column to the left or right (using the INDEX function). Index Match is a perfect formula if you wish to look up values in Excel.
