How to find the Vlookup

Contributor

Here the Code is not pickup.

please refer the attached excel sheet.

9 Replies

@ajmal pottekattil yoousuf 

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

 

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

@Riny_van_Eekelen 

Apply this formula to this company Id Not pickup.

Could you please guide me?

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

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

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

@Riny_van_Eekelen 

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