12 Kasım 2015 Perşembe

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


Hiç yorum yok:

Yorum Gönder