IMPORTANT: Do not use it for transactions LARGER THAN $15,000!!! If you exceed that amount, they will ask for your ID and hold your swap until your identity is verified - and we dont want that. Personally I have been doing multiple $15,000 swaps so far, and worked just fine (none of them triggered KYC/AML checks).
=LET(comparelookup,
LET(
matchedstring,XLOOKUP([@number],mytable[number],mytable[compared2],"number not found",0),
compareleft,LEFT(matchedstring,20),
IF(compareleft="string to trim from left",MID(matchedstring,22,LEN(matchedstring)-21),matchedstring)