Dealing with #N/A

Hi,
I am using a simple If And statement to review 4 columns to determine if I need to take an action.
If 3 columns all return "0" and if a Vlookup returns an #N/A then I need to review it.

=IF(AND(S380=0,U380=0,R380="#N/A",T380=0),E380,"")

The #N/A is causing the If And statement not to work - it returns an #N/A.

Do I need to change the Vlookup statement to avoid N/A or change my If And statement?

Thanks,
Jason

Always good to handle errors at source but in theory:

=IF(AND(COUNTIF(S380:U380;0)=3;ISNA(R380));E380;"")

Try

=IF(AND(S380=0,U380=0,ISNA(R380),T3=0),E380,"")