AllanW
New Member
Hello there,
I've searched around the internet and this forum and found no answer to my problem.
I want to return a 3 x 3 array from preferentially a simple pivot table or alternatively from a larger array.
The return array should use a dynamic center point.
I have spent hours trying to find a solution using GETPIVOTDATA, Index Match and Offset Match but some #REF! or #N/A errors occur.
The really strange part is that errors are generated only when trying to reference columns with specific values of either 1.10 or 1.15 that can be the center point or at the shoulders.
Attached is a worksheet of my attempts to find a solution with some embedded info.
I hope that it is understood what I am trying to achieve.
Looking forward to some help.
Thanks,
AllanW
I've searched around the internet and this forum and found no answer to my problem.
I want to return a 3 x 3 array from preferentially a simple pivot table or alternatively from a larger array.
The return array should use a dynamic center point.
I have spent hours trying to find a solution using GETPIVOTDATA, Index Match and Offset Match but some #REF! or #N/A errors occur.
The really strange part is that errors are generated only when trying to reference columns with specific values of either 1.10 or 1.15 that can be the center point or at the shoulders.
Attached is a worksheet of my attempts to find a solution with some embedded info.
I hope that it is understood what I am trying to achieve.
Looking forward to some help.
Thanks,
AllanW