Forum Discussion
Pass an array as an argument to lookup formula?
Hello,
I have a formula that returns an array of values, and what I'd like to do is expand the formula to take that array, perform a vlookup or index/match on each value in the array to return ...
PS - I know I can sum an array simply using the sum() function, so this question is really about performing the lookup on an array, in an effort to return a second array.