=IF(ISNUMBER(MATCH(A2,sheet2!A:A!sheet3!A:A,0)),"S ame","New To The
Report")

I don't think you can simply click on the worksheet and proceed as you
indicated. When I do that (not the results above), the formula becomes
invalid due to a syntax error. So, how do you correctly reference
multiple worksheets in the same formula without causing a syntax error?


--
ChrisPrather
------------------------------------------------------------------------
ChrisPrather's Profile: http://www.excelforum.com/member.php...o&userid=37743
View this thread: http://www.excelforum.com/showthread...hreadid=573836