Hi!

With names in column A of both sheets, Sheet1 A1:A100 and Sheet2 A1:A50

In Sheet1 B1 enter this formula:

=IF(COUNTIF(Sheet2!A$1:A$50,A1),"","Not on Sh 2")

Biff

"Madduck" wrote in message
...
Hi I have 2 sheets.

On one sheet I have first and last name and other information.
On sheet 2 I have first and last name and other information.

But, sheet 2 does not have all the ppl from sheet 1. ie some are missing.

What I want to do is on sheet 1, identify who is not on sheet 2.

I have tried vlookup and match but can't seem to get it right.

The problem of course is that the last name can be repeated and the first
name can be repeated but not the combination of both.