Forum Discussion
How to find the Vlookup
Here the Code is not pickup. please refer the attached excel sheet.
TRIM will remove leading and trailing spaces, but also multiple spaces within a text string.
CLEAN will remove all non-printable characters from a text string.
You could use them both in one go if you want. Something like:
=CLEAN(TRIM(A1))
Is it possible to solve this error
ajmal_pottekattil_yoousuf OK, I'll give it one more try. VLOOKUP (any lookup function in fact) isn't very good at guessing. This time you are trying to match:
GEO-CHEM MIDDLE EAST with
Geo Chem Middle East LLC
The case of the letters doesn't matter for VLOOKUP but the hyphen triggers the error. For Excel Geo-Chem and Geo Chem are different. It doesn't guess that they are perhaps the same.
- So we can't lookup this.
Is any other method to lookup these values.??
Can i Change the "-" From the Name.??