If Or formula

[PHIL.Pearce84]

Hi,

I have the following formula, it seems to work to the point that if the vlookup returns true then the 0 appears, but when false it will not pull through the value in cell N3.

=IF(OR(VLOOKUP(A6,'Summary Source'!$E:$E,1,FALSE)=A6,VLOOKUP(A6,'Summary Source'!$F:$F,1,FALSE)=A6),0,SUM(N3))

Any help would be greatly appreciated.

 

[Fluff]

How about
=IF(OR(ISNUMBER(MATCH(A6,'Summary Source'!$E:$E,0)),ISNUMBER(MATCH(A6,'Summary Source'!$F:$F,0))),0,N3)

 

[PHIL.Pearce84]

That's amazing thank you, works like a charm.

Would you mind just explaining the ISNUMBER for me?

 

[Fluff]

It simply checks to see if a value is a number.
The MATCH function will either return a number or and error.

 

[kweaver]

From: =IF(OR(ISNUMBER(MATCH(A6,'Summary Source'!$E:$E,0)),ISNUMBER(MATCH(A6,'Summary Source'!$F:$F,0))),0,N3)

IF the match in column E is a number OR if the match in column F is a number, then the result is 0; otherwise, it's N3