*EXACTLY* how many sheets do want to include in this?

What are some of their names? Are you *REALLY* using the default sheet
names, Sheet2,Sheet3 ?

do you *REALLY* need to reference the entire column, sheet2!A:A ?

You'll more than likely need a completely different formula.

Biff

"ChrisPrather"
wrote in message
news:ChrisPrather.2cwllt_1156186513.3879@excelforu m-nospam.com...

=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