You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Tony7659" wrote in message
...
Perfect! It works great. Sorry for the delay, I could not find my message
yesterday to follow up.

Tony.

"T. Valko" wrote:

Not sure what you're trying to do but from what you posted you can
replace
the VLOOKUPs with COUNTIFs:

=IF(COUNTIF(SYS1!$A:$A,$A26)+COUNTIF(SYS1!$R:$R,$A 26),"NY1",IF(COUNTIF(SYS2!$A:$A,$A26)+COUNTIF(SYS2 !$R:$R,$A26),0,""))


--
Biff
Microsoft Excel MVP


"Tony7659" wrote in message
...
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.