Forum Discussion
Spill and INDIRECT
Can anyone help me...?? I have a dynamic array which is derived from a SPILL. What I want to do now is an INDEX(MATCH) on that data (look at the current row value in the SPILL array and find it ...
Thank you very much for your reply, and apologies for taking my time in responding to you - I'd set it to email me when someone replied but for some reason it didn't.
Anyway, I have attached an example sheet showing what I get when I enter the formula as I think it should be. I have also added in another column trying to do the same job but using OFFSET instead of INDIRECT as mtarler suggested. Unfortunately neither were successful.
Thanks again,
Mike
It's not clear what the goal is with the formula. Is this part of a larger project?