SUMPRODUCT and text in cell

[LTUser54]

I am comparing sets of columns in 2 separate worksheets. They have lists of employee names, and compare a list of active pension accounts against a known list of employees.

There are two vendors, and if the person has no account with that vendor, the "#N/A" error message is in the cell. If the person has no account with either vendor I need to track that, so I used this formula to compare the "#N/A" error messages in the key columns:

=SUMPRODUCT(--(ISERROR(G243)),--(ISERROR('TIAA vs Name list'!H243="NO ACCOUNT")))

What I want is for there to be text in the cell if both columns have the "#N/A" error message, but all I get is a "1".

Is there any way to check the columns for "#N/A" error message and have a text message of "No Account" appear in the cell?