TRIM removes leading, trailing or extra spaces so you can just wrap the
cells in TRIM like
=VLOOKUP(TRIM(A1),TRIM(B2:C200),2,0)
entered with ctrl + shift & enter
I didn't know if the spaces were in lookup value or table thus 2 TRIM, I
guess it's probably the table
Regards,
Peo Sjoblom
"matthews_jd" wrote in message
...
I'm having dfficulty comparing imported data from two files. One was
imported from a text file and is not imported in number which can be
fixed.
The more difficult issue is that there is a blank space in some of these
at
the front that causes errors using vlookup or index. Are there any other
functions that can ignore those differences?
|