I am using VLOOKUP to find a number in cell $A26 that has be searched in
different tabs and columns. To accomplish this, I am combining VLOOKUP and OR
without results (#N/A). If I use IFs alone, I would exceed the nested limit.

=IF(OR(VLOOKUP($A26,SYS1!$A:$A,1,FALSE),VLOOKUP($A 26,SYS1!$R:$R,1,FALSE)),"NY1",IF(OR(VLOOKUP($A26,S YS2!$A:$A,1,FALSE),VLOOKUP($A26,SYS2!$R:$R,1,FALSE )),0))

Any ideas?
Tony.