Is there any documentation of the behavior of built-in Excel functions called with array arguments?
Many of Excel's built-in functions can take array arguments. Sometimes the result is documented in the help and sometimes not. So: =IF({1,0,1}, 42, 99) will return {42, 99, 42}. The help for 'IF' covers array arguments. But: =INDEX({2,3,5,7,11}, {2,4}) will return {3, 7}. This is intuitive, but I can't find a Microsoft source that ...