I have 2 tables. For example if the range A1A3 contains the values 5 25 and 38 then the formula MATCH25A1A30 returns the number 2 because 25 is the second item in the range. We are essentially building a tool that can look for an employee and return his or.
INDEX MATCH is not a function in Excel but a combination of two formulas INDEX and MATCH INDEX MATCH can be used as an alternative to old school VLOOKUP.
Combined the two formulas can look up and return the value of a cell in a table based on vertical and horizontal criteria. If match_type is -1 the values in lookup_array should be in a descending order. Index and Match Replace the value 5 in the INDEX function see previous example with the MATCH function see first example to lookup the salary of ID 53. The next argument of the INDEX function is Column Number ie from the selected range of cells from which column we need the result.