Compare two data lists

[Michael7777]

I have two list of names - I want to compare the two lists and either create a column that marks the ones that are duplicates. Or in the alternative create a column and mark the ones that are not on the other list.

Thx

[Motu040602]

If column A holds the 1st set of names and column B holds the second set and the formula to compare is in column C then this formula should work.

=IFERROR(IF(VLOOKUP(B4,$A$1:$B$5,1,FALSE)=TRUE,"","duplicate"),"")

I have also attached a sheet for testing. I hope this helps

[Michael7777]

thx - I will give this a try.