excel 2000

[holy dog]

Have user that has four workbooks. Each workbook has a column of names. This
user wants to be able to compare the columns in each workbook and flag the
names that are the same in each workbook. Is this possable, and if yes how?
Thanks much