How do you reference the values in a specific column when the array brings back multiple columns

Q&A
1

I want to use the Accountandsubaccountwithhistory formula to bring back the list of Account/subaccount combinations that have been used in the system. Then I want to use the Accountendingbalance formula and need to reference the Account and subaccount separately from the results of the Accountandsubaccountwithhistory formula. How do I do this? If I try and reference the account field and add the # sign (example A2#) get error because the array has multiple columns that are brought back.

2

If you want to reference just the Account Number (and not the subaccount), you can use the Excel, INDEX function to reference just the first column of the array.

e.g., =AccountTurnover(Connection,“Actual”,INDEX(A2#,1),StartDate,EndDate)

3

Thank You Harry. This is exactly what I was looking for.