Nov 10 2022 11:09 PM
Here the Code is not pickup.
please refer the attached excel sheet.
Nov 11 2022 01:15 AM
Nov 11 2022 01:26 AM
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.
I know I don't know anything (Socrates)
Nov 11 2022 04:16 AM
Nov 11 2022 04:50 AM
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.
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:
=CLEAN(TRIM(A1))
Nov 11 2022 11:42 PM
Is it possible to solve this error
Nov 12 2022 12:25 AM - edited Nov 12 2022 12:27 AM
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