Forum Discussion
ajmal_pottekattil_yoousuf
Nov 11, 2022Iron Contributor
How to find the Vlookup
Here the Code is not pickup. please refer the attached excel sheet.
NikolinoDE
Nov 11, 2022Gold Contributor
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)