Dear Experts,
I have a formula combining formula IF with IFERROR and that works because brings result without any error in the cell:
=IF(C2="","",IF(B2="C","C",IFERROR(VLOOKUP(C:C,Status!$F$4:$F$200000,1,0),"No action yet")))
This means that technically possible to have IFERROR as nested after IF.
But when trying to apply the following formula which is just adding one VLOOKUP compare to the before one, it brings result as #N/A:
=IF(C3="","",IF(VLOOKUP(C:C,Status!$F$4:$F$200000,1,0)>0,"Group de-duplicated",IFERROR(VLOOKUP(C:C,Status!$F$4:$F$200000,1,0),"No action yet")))
Could you please help to spot the eventual syntax issue in the second one? My target is to not bring #N/A in the cell
Thanks in advance,
seems wrong, do you mean C3 instead?
=IF(C3="","",IF(VLOOKUP(C3,Status!$F$4:$F$200000,1,0