Replacing data with power query

i am doing a scrub matching file from data pulled from my company CRM. as you may know most of the information here (company names) are not static. i CANT use fuzzy matching because it makes it worse. so i am trying to make a static list.

my list is a 100% accurate i tried myself with xlookup and checking UNIQUES names are all written in the exact same way in the static list, even manually went through some of the examples

the problem? while merging the queries tho the names are there the way its on the data and its static version to replace, power query is not detecting some of them. like yeah its working for the 30% of the inputs but the other 70% are appearing as null/blanks. so my theory is correct but why is it not applying to all of them values?

english is not my first language so apologies in advance if its hard to understand. i dont want to make this long but i can also further explain step by step how i am doing it.

thank you