SUMPRODUCT or INDEX MATCH

[David Jenkins]

Hi there,

What is better to use in a spread sheet that is going to have a lot of these formulas? What I mean to say is there a performance benefit of one over the other or is their potentially an alternative?

I will be matching on a Week Number and Department Name to return a value. Sometimes there might be three or four of these in one cell to perform a calculation.

Regards,

Dave

 

[Somendra Misra]

Hi David,

Can you upload a sample file with desired output, then same can be tested.

Regards,