Ok......

Use this:

=IF(ISNUMBER(MATCH(A1,Sheet2!A:A,0)),"Same","New To The Report")

Biff

"ChrisPrather"
wrote in message
news:ChrisPrather.2crbsi_1155940513.7047@excelforu m-nospam.com...

The function you provided will work just fine except that I want to
paste some text in a cell if there is a match ("Same") and if there
isn't a match ("New To The Report"). I don't know how your function
will accomplish that.

=ISNUMBER(MATCH(A1,Sheet2!A:A,0))

Here is my goal if I wasn't clear earlier. I have a set of text names
in column A. I want to compare each cell in column A from sheet1 to
each cell in column A from sheet2. IF there is any match, I want to
print "Same" or "New To The Report" in Column B to the right of each
cell. I hope that makes more sense.

Sheet1

abcd Same
aecd New To The Report
acfe Same
akjllk Same

Sheet2

abcd
acde
akjllk
acfe


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