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 ...
Why don't you just use OFFSET instead of INDIRECT(ADDRESS()):
OFFSET(H16#,-1,0)
oh and as to why, I'm pretty sure INDIRECT() doesn't work with array input