Hello,

I am trying to do an INDEX MATCH on data that is dynamic... the index function requires an array, and usually this array is static but in my case it is dynamic (both the rows and columns)(the dimension will not always be the same). Is there a way to create a variable array, so that I can do something like INDEX(namedarray, match(....))? Also, this named array is not on the same sheet as the INDEX function, so I don't know whether this would affect anything.

THANKS!