My lookup fails because “Acme Inc.” has a char(160) between words, so VLOOKUP treats it as different from the normal “Acme Inc.”, and TRIM/CLEAN don’t touch it in Excel 365. What’s your fastest on-the-fly fix during a paste — find/replace with CHAR(160), a quick Power Query step, or something simpler?