Forum Discussion

Leon_Redclifft's avatar
Leon_Redclifft
Copper Contributor
Feb 24, 2020
Solved

Need help with =IFerror function

Hi, I would like to ask how do I add IFERROR in this situation? I have been spending 1 hour on this one since one of the column have #N/A and im trying to make it as a blank.   =IF(VLOOKUP(B4,'Pla...
excel
Formulas and Functions
  • JKPieterse's avatar
    JKPieterse
    Feb 24, 2020

    Leon_Redclifft Hard to answer without knowing the goal of the formula. BUt I'd guess this should suffice:

    =IFERROR(IF(VLOOKUP(B4,'Planning S15'!A:AT,2,0)>0,(IF(LEN(VLOOKUP(B4,'Planning S15'!A:AT,2,0))=0,"",(VLOOKUP(B4,'Planning S15'!A:AT,2,0)))),(IF(LEN(VLOOKUP(B4,'Planning SM'!A:N,2,0))=0,"",(VLOOKUP(B4,'Planning SM'!A:N,2,0))))),"")
JKPieterse's avatar
JKPieterse
Silver Contributor
Feb 24, 2020

Leon_Redclifft Hard to answer without knowing the goal of the formula. BUt I'd guess this should suffice:

=IFERROR(IF(VLOOKUP(B4,'Planning S15'!A:AT,2,0)>0,(IF(LEN(VLOOKUP(B4,'Planning S15'!A:AT,2,0))=0,"",(VLOOKUP(B4,'Planning S15'!A:AT,2,0)))),(IF(LEN(VLOOKUP(B4,'Planning SM'!A:N,2,0))=0,"",(VLOOKUP(B4,'Planning SM'!A:N,2,0))))),"")

Resources