Approximate matches with vlookup?

[Keith R]

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

 

[robotman]

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...

 

[T. Valko]

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