How To Lookup Values with INDEX and MATCH Plus Adding Rows or Columns In Excel

You can use the combination of INDEX and MATCH to look up values in an array. But did you know that you can also use this combination in conjunction with the SUM function to total up rows or colums? Here’s how!

You can download the file here and follow along. If you get a preview, look for the download arrow in the upper right hand corner.

Happy Excelling!

Free Download!

Subscribe to Download Your FREE Copy of
"My 70+ Favorite Excel Keyboard Shortcuts" Today!


  1. How To SUM A Range Of Values In An Array Using INDIRECT, ADDRESS, and MATCH Functions In Excel | Excel Bytes - January 7, 2016

    […] You can find the INDEX/MATCH tutorial that includes summing the rows or columns here. […]

Leave a Reply