ignore error #N/A in if or statement

[Chris_Ingram]

I'm trying to do an if/or statement. However one or more of my cells contains a legitimate error (#N/A) from vlookups which I cannot fix in order for another formula to work.

Let's say the 3 columns are G,H and I. These columns are returning TRUE, FALSE or #N/A as their values. If any of them show FALSE, i want this to show FALSE in column J, otherwise leave blank.

In column J I have =IF(OR(G2=FALSE,H2=FALSE,I2=FALSE),"FALSE"," ")

I've tried playing around with ISNA and IFISERROR/IFERROR, but can't seem to get it.

 

[JoeMo]

Does this do what you want?

=IFERROR(LOOKUP(FALSE,G2:I2,G2:I2),"")

 

[Chris_Ingram]

Perfect, thank you!

 

[JoeMo]

Perfect, thank you!

You are welcome - thanks for the reply.