Using Excel Functions Together

Which function can be used together? And which of these combinations offers strong solutions?

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