Hi,
I am trying to compare last months cost ledger with this months. Last month I went through some 7000 line items and assigned them a cost heading manually as the accounts system does not do it for me. I don't want to revisit another 7000 line items in the new ledger rather the new ledger items which have landed in the month.
Unfortunately I don't have any unique transaction ID's so I'm having to run an index / match formula based on an internal transaction reference and a description (2 criteria).
However, I've only got as far as running the formula based on one criteria and would like to extend this to two (or even three) to ensure as many entries are captured and help in minimising coding of old items.
Where Column K (Internal Ref for this month) and Column L (External Ref this month) and Columns X to Z contain the Internal Ref, External Ref and Cost Head to Last Month:
T8= =INDEX(X8:Z7213,MATCH(K8,X8:X7213,0),3)
Can anyone kindly point me in the right direction?
I am trying to compare last months cost ledger with this months. Last month I went through some 7000 line items and assigned them a cost heading manually as the accounts system does not do it for me. I don't want to revisit another 7000 line items in the new ledger rather the new ledger items which have landed in the month.
Unfortunately I don't have any unique transaction ID's so I'm having to run an index / match formula based on an internal transaction reference and a description (2 criteria).
However, I've only got as far as running the formula based on one criteria and would like to extend this to two (or even three) to ensure as many entries are captured and help in minimising coding of old items.
Where Column K (Internal Ref for this month) and Column L (External Ref this month) and Columns X to Z contain the Internal Ref, External Ref and Cost Head to Last Month:
T8= =INDEX(X8:Z7213,MATCH(K8,X8:X7213,0),3)
Can anyone kindly point me in the right direction?
