csehz

asked on

# 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:

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:

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,

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,

ASKER CERTIFIED SOLUTION

membership

Create an account to see this answer

Signing up is free. No credit card required.

ASKER

Thanks very much it works

C:C,Status!$F$4:$F$200000,1,0C:C,Status!$F$4:$F$200000,1,0seems wrong, do you mean C3 instead?

=IF(C3="","",IF(VLOOKUP(

C3,Status!$F$4:$F$200000,1,0C3,Status!$F$4:$F$200000,1,0