I have pulled data from Microsoft query with ODBC. When I try to link this data to a vertical look up on a separate tab, excel is not recognizing the data to be identical and therefore it’s not linking my pages.

I noticed that the ODBC file adds extra spaces, with the find and replace I was able to eliminate this problem. But it appears that the table still is not identical and I am not sure why….. I have tried to TRIM and CLEAN the cells with no luck. Also I noticed that if I am in the ODBC file and click on the cell, then hit F2, then enter, the formula will work correctly, but I can’t possibly do this for 30,000 lines.

Maybe it’s possible to use a different formula other than vertical look up that would give me the same result, I just don’t know of one. I hope this was specific enough.

Any help is much appreciated.