I have two worksheets, and I need to vlookup the values from the cells on
one worksheet against the other. The problem is that one or both of the
source and comparison values may have trailing spaces, so I thought trim
would be appropriate- something like:

=VLOOKUP(TRIM(C7),TRIM('revised date'!trimB5:G878),6,FALSE)

but that isn't working either. I suspect that most of the time I have one or
more char(32) on the end of the comparison value array cells, so I'm open to
any suggestions on how to ensure the match. Each number may have a different
number of digits or characters, so I can't just use left(8), for example.

Thanks for any ideas,
Keith