I’m not sure where the error is, or missing something in the INDEX MATCH formula.
Only happens when there is a zero anywhere in the array of numerical values.
percent calculation, the sum was rightfully zero, Range B7.
and
percent calculation, the sum was rightfully (0.08), Range F6.
But in Cell Range (I13) I get a blank when calculating for percent variance
Therefore in the result columns, K and L I get the same number twice.
How can this “paradox”, for lack of better terms be corrected ?
Thanks