This is an excerpt from Pierre Leclerc (www.excel-vba.com)


Excel functions and formulas

The 2 Most Important

Excel Functions AND
Formulas

 

SUMPRODUCT

AND

INDEX/MATCH

 

 

VLOOKUP and other old lookup Functions in Excel

 

See the much better INDEX/MATCH and SUMPRODUCT

SUMPRODUCT     INDEX/MATCH     SUBTOTAL     ISERROR     HLOOKUP     LOOKUP     VLOOKUP
COUNTIF     SUMIF    

 

left arrow Back home