Forum Discussion
edit cells to add trailing space
So the lookup value has a trailing space but the first column of the lookup range does not?
If that is correct:
Let's say your formula looks like =VLOOKUP(B2, lookup_range, 2, FALSE)
You can change that to =VLOOKUP(--B2, lookup_range, 2, FALSE)
That should take care of the trailing space...
It might be possible to avoid that, please tell us more about the setup and what you want to look up.
HansVogelaar Iam pulling data from two tools and exporting the file to multiple spreadsheets. The source file that I am basing my VLOOK up on is fine( it is a microsoft tool). The second tool ASTRA when extracting the data into Excel( or CSV) does not include a space at the end key field. 1234 vs 1234( blank at the end). The VLOOKUP does not find a hit unless I add a space at the end of the 1234.
So the lookup value has a trailing space but the first column of the lookup range does not?
If that is correct:
Let's say your formula looks like =VLOOKUP(B2, lookup_range, 2, FALSE)
You can change that to =VLOOKUP(--B2, lookup_range, 2, FALSE)
That should take care of the trailing space...
- Excellent. I'll give that a try. Thank you!