# Excel 2010 - IF with inside IFERROR

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

Ryan Chong

=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")))

seems wrong, do you mean C3 instead?

=IF(C3="","",IF(VLOOKUP(C3,Status!\$F\$4:\$F\$200000,1,0)>0,"Group de-duplicated",IFERROR(VLOOKUP(C3,Status!\$F\$4:\$F\$200000,1,0),"No action yet")))