How to find the Vlookup

[ajmal pottekattil yoousuf]

Here the Code is not pickup.

please refer the attached excel sheet.

[#2]

@ajmal pottekattil yoousuf 

See attached. You need to use wildcards to match partial lookup values.

[#3]

@ajmal pottekattil yoousuf 

How to correct a #N/A error in the VLOOKUP function

Use this formula if you want to bypass the error message.

=IF(ISERROR(VLOOKUP(B2,Sheet2!$C$2:$D$3,2,FALSE)),"",VLOOKUP(B2,Sheet2!$C$2:$D$3,2,FALSE))

File with example is included.

Hope I was able to help you with this info.

NikolinoDE

I know I don't know anything (Socrates)

[#4]

@Riny_van_Eekelen 

Apply this formula to this company Id Not pickup.

Could you please guide me?

[#5]

@ajmal pottekattil yoousuf 

That's because you have a space at the end in "HAVELOCK ONE INTERIORS LLC " in B4, whereas the first part of C4 in sheet2 has a comma directly after "LLC". Remove the space in B4 or add one before the comma in C4.

[#6]

In this sheet more than 2000 customers are present.
Is any equation is remove the blank space automatically.

[#7]

@ajmal pottekattil yoousuf 

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

[#8]

@Riny_van_Eekelen 

Is it possible to solve this error

[#9]

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

[#10]

So we can't lookup this.
Is any other method to lookup these values.??
Can i Change the "-" From the Name.??