Quote Originally Posted by jcampbell
NBVC,

Great, thanks, that works!

Is there any rhyme or reason to which functions can be used to generate intermediate array outputs, and which cannot (e.g. vlookup cannot, lookup can)?

Jonathan
I'm not entirely sure, but... I think it just depends on the design of the function and how much detail went over each design by Microsoft (some work in array formulas and some don't)... I tend to just try different functions and go by trial and error...