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