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?