VLOOKUP Returning #NA

Hello,

I have used VLOOKUP a fair amount but I am stumped why I keep on getting #NA.

I have checked if additional text is in a string -- hence I used the TRIM function to clean it

Does anyone have any ideas? I have attached the data for your reference. I am looking to return the state in column G (CMS Bundled Payment Data Tab) based on the city being present in both tables.

Any help, much appreciated.

All the best,
Adam