AND errors

  • Thread starter Thread starter Coppertop
  • Start date Start date
C

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),"-","+")

They work great and return either a minus aor a plus sign.

Now I want to create a large statement that checks all
three tables so that the result returned is either plaus
or minus.:

=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 am not
seeing the simple typo.
 
Copper,

Try

=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)),"-","+")
 
Back
Top