The simplest way is to perform the calculation in the array and return this array to the Excel spreadsheet with function BS_FILLARRAY of the Add-in A-Tools.
=BS_FILLARRAY(array, ["Options"])
Example:
1. Return array from function INDEX()
=bs_FillArray(INDEX(E5:N14,,P4)))
2. Append multiple array and return it to spreadsheet
=bs_FillArray(BS_ARRAY2D(A1:D10, A14: D20, D1:G20))
3. Append multiple array and return it to spreadsheet, set option INSERT in formula
=bs_FillArray(BS_ARRAY2D(A1:D10, A14: D20, D1:G20), "INSERT=YES")
3. Append multiple array and return it to spreadsheet, set option INSERT, create NAME in formula
=bs_FillArray(BS_ARRAY2D(A1:D10, A14: D20, D1:G20), "INSERT=YES; NAME=MixData")
Video Help 1
Video Help 2
Video Help 3