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