VLOOKUP Trim vs. No Trim
 

So I have this data population. When I VLOOKUP( etc...) it will pull
back data for some, but not for others since there trailing spaces. So
I modify the formula to VLOOKUP(TRIM(), etc...), which fixes the space
issue, but then stops returning values for cells that previously
returned data. It's like I have to choose one or the other. Anyone
else experience this?

VLOOKUP Trim vs. No Trim
 

I think you have spaces in both, the range in which you are looking the match
and the original to be matched value.

You must format/trim the range to search and then your below formula with
TRIM() will work.

Hope this makes sense!!
--
Pranav Vaidya
VBA Developer
PN, MH-India
If you think my answer is useful, please rate this post as an ANSWER!!


"Kigol" wrote:

So I have this data population. When I VLOOKUP( etc...) it will pull
back data for some, but not for others since there trailing spaces. So
I modify the formula to VLOOKUP(TRIM(), etc...), which fixes the space
issue, but then stops returning values for cells that previously
returned data. It's like I have to choose one or the other. Anyone
else experience this?

VLOOKUP Trim vs. No Trim
 

On Oct 3, 11:11 am, Pranav Vaidya
wrote:
I think you have spaces in both, the range in which you are looking the match
and the original to be matched value.

You must format/trim the range to search and then your below formula with
TRIM() will work.

Hope this makes sense!!
--
Pranav Vaidya
VBA Developer
PN, MH-India
If you think my answer is useful, please rate this post as an ANSWER!!



"Kigol" wrote:
So I have this data population. When I VLOOKUP( etc...) it will pull
back data for some, but not for others since there trailing spaces. So
I modify the formula to VLOOKUP(TRIM(), etc...), which fixes the space
issue, but then stops returning values for cells that previously
returned data. It's like I have to choose one or the other. Anyone
else experience this?- Hide quoted text -

- Show quoted text -

I trimmed that range as well manually. The I trimmed them both. Still
doesn't work. It's not like it is leaving certain cells out, it is
picking and choosing which cells to pull data from based on the
formula. It's driving me nuts. Thanks for the suggestion though.