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

**URL:** <https://community.velixo.com/t/how-do-you-reference-the-values-in-a-specific-column-when-the-array-brings-back-multiple-columns/145>\
**Category:** Q&A\
**Tags:** Acumatica\
**Created:** [May 20, 2026, 5:36pm UTC](https://community.velixo.com/t/how-do-you-reference-the-values-in-a-specific-column-when-the-array-brings-back-multiple-columns/145 "2026-05-20T17:36:09Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Dianah](https://community.velixo.com/letter_avatar_proxy/v4/letter/d/3be4f8/32.png) [@Dianah](https://community.velixo.com/u/Dianah)\
**Post date:** [May 20, 2026, 5:36pm UTC](https://community.velixo.com/t/how-do-you-reference-the-values-in-a-specific-column-when-the-array-brings-back-multiple-columns/145/1 "2026-05-20T17:36:09Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![Harry](https://community.velixo.com/user_avatar/community.velixo.com/harry/32/21_2.png) [@Harry](https://community.velixo.com/u/Harry)\
**Post date:** [May 20, 2026, 6:23pm UTC](https://community.velixo.com/t/how-do-you-reference-the-values-in-a-specific-column-when-the-array-brings-back-multiple-columns/145/2 "2026-05-20T18:23:29Z")

</div>

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)

---

<div class="post-metadata">

**Author:** ![Dianah](https://community.velixo.com/letter_avatar_proxy/v4/letter/d/3be4f8/32.png) [@Dianah](https://community.velixo.com/u/Dianah)\
**Post date:** [May 20, 2026, 7:48pm UTC](https://community.velixo.com/t/how-do-you-reference-the-values-in-a-specific-column-when-the-array-brings-back-multiple-columns/145/3 "2026-05-20T19:48:29Z")

</div>

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