Every item in my 24k long Array is padded with trailing spaces such that each element is 50 characters wide, the actual visible text in the Array is usually much less.This is a result of the way the Array was created. The Search Criteria is the same length as the visible text in the Array. As a result of the disparity in their respective lengths Vlookup fails.
I don’t know how to clean up (remove) the training spaces other than manually, is there any other solution to deal with this problem?
Here’s an example of a failure using vlookup function in column C =VLOOKUP(A1,B$1:B$4,1,1 )
001Trolling.2017.WEBRip.mp4 001Trolling.2017.WEBRip.mp4 #N/A
This is after removing the not visible spaces from column B
001Trolling.2017.WEBRip.mp4 001Trolling.2017.WEBRip.mp4 001Trolling.2017.WEBRip.mp4