Search letters and numbers to see if exist in another column by at least 7 characters

Thank you Glenn and Hans, I was not aware the difference between the two excel version, apologize for that. I will learn a lot of my very first posted issue here.

I am very newbie to create formulas and I still do not get it to work, changing the SEQUENCE(10) with ROW($1:$10) and doing the command afterwards.

It still gives me No match as a result.

If I type ROW($1:$100) it will take 100 rows I assume also, as I do not know how many rows I will have yet.
Is it also taking into account the length may vary, it will not be as the example always using just 10 characters? They are also not on the same row, the matching characters can be anywhere in the columns.

Thank you!