ccarmichael
New Member
- Joined
- May 20, 2015
- Messages
- 9
How can I add an INDIRECT function to an existing INDEX/MATCH formula?
The existing formula is (for one account balance):
=INDEX('FinanceDetail'!B2:B50,MATCH(TRUE,INDEX(('FinanceDetail'!B2:B50<>0),0),0))
The "FinanceDetail" tab/sheet contains dates (column A), and account balances over time in columns B, and C. Each account balance is not always updated on certain dates, so some gaps exist. The above formula works for this condition, except that new dates are added in row 2, which automatically updates the formula above (B2:B50 reference). I understand that the INDIRECT function can solve this issue, but I have ran into various syntax errors. Any help would be greatly appreciated.
The existing formula is (for one account balance):
=INDEX('FinanceDetail'!B2:B50,MATCH(TRUE,INDEX(('FinanceDetail'!B2:B50<>0),0),0))
The "FinanceDetail" tab/sheet contains dates (column A), and account balances over time in columns B, and C. Each account balance is not always updated on certain dates, so some gaps exist. The above formula works for this condition, except that new dates are added in row 2, which automatically updates the formula above (B2:B50 reference). I understand that the INDIRECT function can solve this issue, but I have ran into various syntax errors. Any help would be greatly appreciated.