Reconcile Bank with Transactions using EFT Control Number

[EXCEL_NEWBI]

Hello All!

Looking for help with a formula to reconcile bank data against my Transactions data.
Sample file has some detail,

Would like to match
Option 1 - Match EFT# and amount, then return "R" in "Column J" if match or "Y?" if match EFT nut not the amount or "?" if ETF/$$ don’t match
Option 2 - Match EFT#, then return "R" in "Column K" if match or "?" if no match

Bank Register captures EFT number but for different insurances numbering format is different (examples in RED)
COMM OF MASS HCCLAIMPMT TRN*1*0000178I0010000*1046000000*104360000\

Option 1 and Option 2 are both important as some insurances lump multiple transactions together and pay in one EFT -- so EFT may match but amount may not.

[EXCEL_NEWBI]

Hello again - I looked at all previous posts under Bank Reconcile but none addresses 'matching EFT number from ledger' with Bank statement data where EFT numbers in "Description text" (and sometimes has characters before / after.. Kindly help.. thank you