Excel INDEX / MATCH function instead of VLOOKUP – formula examples

lookup_value - this is the number or text you are looking for. This can be a value, a cell reference or logical value. lookup_array-a range of cells being searched. match_type - this parameter tells the MATCH function whether you want to return an exact m

www.ablebits.com