lost_in_the_sauce
Board Regular
- Joined
- Jan 18, 2021
- Messages
- 128
- Office Version
- 365
- Platform
- Windows
Trying to get this to work from an array with the following column titles:
And the formula sheet
with rows that have account names. Trying =index('DATA'!$A$1:$O$13758,match('FORMULAS'!E$2,'GP 2017-2021'!$H:$H,0),match('FORMULAS'!E$3,'GP 2017-2021'!$I:$I,0),match('FORMULAS'!$C$1,'GP 2017-2021'!$D:$D,0),match('FORMULAS'!$C8,'GP 2017-2021'!$K:$K,0)) and getting errors - I want to pull the Period Balance in column O on 'DATA' if it matches Year (H), Period ID (I), Company (D), and Account Description (K) from the 'FORMULAS' sheet. Currently getting "Too Many Arguments."
| Company Code | Department Code | Account Code | Company | Account | Department | Identifier | Year | Period ID | Account Number | Account Description | Debit Amount | Credit Amount | Company | Period Balance |
And the formula sheet
| Company | Jan-17 | Feb-17 | Mar-17 | Apr-17 | May-17 | |
| 2017 | 2017 | 2017 | 2017 | 2017 | ||
| 1 | 2 | 3 | 4 | 5 |
with rows that have account names. Trying =index('DATA'!$A$1:$O$13758,match('FORMULAS'!E$2,'GP 2017-2021'!$H:$H,0),match('FORMULAS'!E$3,'GP 2017-2021'!$I:$I,0),match('FORMULAS'!$C$1,'GP 2017-2021'!$D:$D,0),match('FORMULAS'!$C8,'GP 2017-2021'!$K:$K,0)) and getting errors - I want to pull the Period Balance in column O on 'DATA' if it matches Year (H), Period ID (I), Company (D), and Account Description (K) from the 'FORMULAS' sheet. Currently getting "Too Many Arguments."
