Approximate matches with vlookup?
 

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

Approximate matches with vlookup?
 

If there is a part of a field you can search for in the other sheet,
you can use the SEARCH function which lets you find a portion of a
string with in another and use wild characters...

Approximate matches with vlookup?
 

The problem is that one or both of the source and comparison values may
have trailing spaces

Try this:

=VLOOKUP(TRIM(C7)&"*",'revised date'!B5:G878,6,0)

Biff

"Keith R" wrote in message
...
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