Formula required

[MISSNS46]

Hi guys,
I was wondering if anyone could possibly assist me.
So I have an exercise that I need to complete where one account with the debit transfers is on one tab and the account where it's being transferred to with the credit amounts is on another tab.
I was advised to mark each transaction (debit) with an "a,b,c" etc., and then the credit transactions with the specific letter to which the transactions match.
Is there a formula that will make this easier for me?
Example below:

 

[ExceLoki]

this should work for you, as long as dont have multiple amounts on the same date. if you had another unique data point for each (transaction id, confirmation code, etc) that would be the same on both lists, then could use that also.
----------------

Book1
	A	B	C	D	E	F	G
1	Bank	Date	Ref	Transaction Type	Description	Amount	mark
2	ACC1	7/5/2021	Add	Credit Transfer	From ACC2 to Acc1	$ 600,000.00	a
Acc 1

---------------

Book1
	A	B	C	D	E	F	G
1	Bank	Date	Ref	Transaction Type	Description	Amount	mark
2	ACC2	7/5/2021		Debit Transfer	From ACC2 to Acc1	$ (600,000.00)	a
Acc 2

Cell Formulas
Range	Formula
G2	G2	=INDEX('Acc 1'!G:G,MATCH(1,(B2='Acc 1'!B:B)*(F2=('Acc 1'!F:F)*-1),0))