You could use an additional column (C) in both worksheets.

Then put this type of formula in C1:

=isnumber(match(b1,'sheet2'!b:b,0))
and drag down

Change the sheet name to match the other sheet (huh?).

Then drag down.

You'll end up with a column True/false. True means there was a match.

woodlot4 wrote:

I don't know if I am off base here or not but I am looking for a similar
formula to compare two different lists of information. Chip's info
seems to discuss only how to compare for duplicate in one column. What
I see being asked here and what I wish to have is a formula that will
compare column b in worksheet 1 with column b in worksheet 2 and let me
know if there are any duplicate names or details.

the links to Chips info do not help with this.
Does anyone have some better helps or options? I had one once but
can't seem to find it now.

--
woodlot4
------------------------------------------------------------------------
woodlot4's Profile: http://www.excelforum.com/member.php...o&userid=26613
View this thread: http://www.excelforum.com/showthread...hreadid=333388

--

Dave Peterson