Formula or logic needed to match various criteria

[cterrence]

Hi All

Could you please assist, 

Project

I need to reconcile a statement using multiple criteria

I have attached a file which contains a sample source and the finished result I want

Task 1 - Need to extract the first column (A Number) based on first 4 digits - Completed

Task 2 - Need to extract the column  (A Account) based on last 4 digits - Completed

For eg

Now the main task

A Number	Voucher	Date	A Account	Amount	JA	LA
1000-035324	ABJ000004623	30/06/2022	1026150-2235-AB0751-8340	-  1,500,000.00	1000	8340
1000-035324	ABJ000004623	30/06/2022	3025200-2235-AB0751-8340	1,500,000.00	1000	8340
1000-035324	ABJ000004623	30/06/2022	1026150-2235-AB0751-8234	-        25,000.00	1000	8234
1000-035324	ABJ000004623	30/06/2022	3025200-2235-AB0751-8234	25,000.00	1000	8234
1000-006139	ABJ000002339	30/06/2021	3025200-2235-AB0751-8245	-        45,000.00	1000	8245
8245-006787	ABJ000002398	30/06/2021	1026150-2235-AB0751-1000	45,000.00	8245	1000
8245-006787	ABJ000002398	30/06/2021	1026150-2235-AB0751-1000	1,500.00	8245	1000

If data extracted from task 1 and task 2 matches with date column (Date) and amount column (Amount) then give me a Match else give No Match

Points
1. The data in JA and LA can come in any order like the ones I have highlighted in bold
2. All the matching criteria could be anywhere in the source. 

I was thinking of adding a helper column where I add column  JA and LA and use the helper as a lookup to match amount and date


Please help

[caltang]

Looks fine on my end:

[caltang]

Hmm, maybe let's reset the workflow. You want to join between LA and JA right?

But there are some occasions where LA matches to JA and vice versa - thereby flagging it as YES right?

[cterrence]

Thanks @caltang 

I  have added additional columns to showcase the JA/LA switch, I have highlighted the problematic ones in yellow 

[caltang]

Hmm, I've checked the data manually and got this:

This should be right.