compolex formula

[Coppertop]

I have a series of vlookup statements I want to incorporate into a
single statement.
Individually they look like this :
=IF(ISNA(VLOOKUP(C2,$A$2:$A$280,1,FALSE)=FALSE),"-","+")
=IF(ISNA(VLOOKUP(E2,$C$2:$C$280,1,FALSE)=FALSE),"-","+")
=IF(ISNA(VLOOKUP(G2,$E$2:$E$280,1,FALSE)=FALSE),"-","+")

I want to create a large statement that checks all three tables. Like
so:

=IF(AND(ISNA(VLOOKUP(C2,$A$2:$A$280,1,FALSE)=FALSE)),(ISNA(VLOOKUP(E2,$C$2:$C$280,1,FALSE)=FALSE)),(ISNA(VLOOKUP(G2,$E$2:$E$280,1,FALSE)=FALSE)),"-","+")

"The formula you typed contains an error is all that I get"

I've gone over this many times and see no obvious errors. Is this the
right method or have I gone blind and not seeing the simple typo.

 

[John Tjia]

Try this:

=IF(AND(ISNA(VLOOKUP(C2,$A$2:$A$280,1,FALSE)=FALSE),ISNA(VLOOKUP(E2,$C$2:$C$280,1,FALSE)=FALSE),ISNA(VLOOKUP(G2,$E$2:$E$280,1,FALSE)=FALSE)),"-","+")

In your original below, I've marked with "[" or "]" the parentheses to
remove
and "}" the parenthesis to add.