Troubleshooting Data Type Issues in Lookup Functions

I've got a column of business names that I trimmed using a formula and then copied into a new column. I cannot lookup against these values for some reason (if I delete the contents and replace with the same text the lookup works). If this was Excel I'd say there was an issue with the data type but in clay I'm not sure. Any ideas please?