Forum Discussion
How to find the Vlookup
Here the Code is not pickup. please refer the attached excel sheet.
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.??