So my manager and I have been working on this huge formula that we just couldn’t get to work. We have finally narrowed the problem down to the “or” formula - it continues to display an error (#N/A). Below is a little pretend spreadsheet:

A B C

1 1 1

2 2 2

3 3 3

@ 4 0

5 5 5

6 6 6

4 =IF(OR(ISERROR(VLOOKUP(A8,‘Sheet2’!A1:A6,1.0,false)),VLOOKUP(A8,A1:A6,2.0,false)=0.0),“TRUE”,“FALSE”)

So there are columns A, B & C, and a total of 6 rows. I have made the cell value the same as the row number, with the exception of “cell” A8, which has a value of 4. “Cell” A4 is supposed to be blank, but it doesn’t display right on the board if I do it that way, so @ will have to suffice.

I believe the formula works on columns B & C. From what I understand though, it should not return #N/A because of the blank. Am I wrong? Does this need to be set up differently?