VLOOKUP and MATCH
IFERROR and VLOOKUP
INDEX and MATCH
SUMIF and INDEX and MATCH
LEFT and FIND
RIGHT and FIND
MID and FIND
IF and AND / OR
We can see MATCH function too many. Because it produces the number of item in a list or column. So this number used in VLOOKUP as a third parametet (column number).
for more explanation:
www.excelci.com
