Hi @ramerkw, @Mark.S, @rshahk, @duraid - I have a new version of this solution here Automatic “Transfer” Matcher with Clickable Links (Google Apps script version) - Google Sheets / Show & Tell - Tiller Community.
I rewrote it using Google Apps script and it’s a massive improvement in terms of performance and addresses most of the ideas @rshahk suggested. Let me know if you give it a try.
-Alan