Posted to microsoft.public.excel.programming

Kigol

external usenet poster

Posts: 36

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?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
trim and vlookup dun work	Seeking help[_9_]	Excel Programming	1	August 18th 06 07:17 AM
vlookup with trim function	rodgie	Excel Discussion (Misc queries)	5	June 6th 06 12:02 PM
Vlookup & Trim	Paperback Writer	Excel Discussion (Misc queries)	4	February 4th 06 06:58 PM
VBA Trim and Application.worksheetfunction.Trim	Hari Prasadh	Excel Programming	3	January 19th 05 02:22 PM
Trim like worksheet Trim	Bob Phillips[_5_]	Excel Programming	0	August 20th 03 07:10 PM

All times are GMT +1. The time now is 07:34 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us