INDEX MATCH is not a function itself in Excel rather it is a combination of two different formulae and is very powerful than VLOOKUP we will check this in short. However we have several alternatives that can be used as an alternative to VLOOKUP function in excel. To create INDEX MATCH formula we need to replace MATCH with row_argument of INDEX.
INDEX C3E11MATCHFrantz B3B1102 Taking things one step further well use the value from H2 in MATCH.
Next at the 150 mark the formula is changed to work with 2 criteria. However we have several alternatives that can be used as an alternative to VLOOKUP function in excel. INDEX E5E113 and INDEX returns a final result of 1700. MATCH function returns the index of the first appearance of the value in an array single dimension array.