Nov 11 2022 01:26 AM
Use this formula if you want to bypass the error message.
File with example is included.
Hope I was able to help you with this info.
I know I don't know anything (Socrates)
Nov 11 2022 08:37 PM
Nov 11 2022 11:06 PM
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:
Nov 12 2022 12:25 AM - edited Nov 12 2022 12:27 AM
@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.
Nov 12 2022 12:32 AM