You could try:

Assuming the list of 998 names is in column A, starting in row 1 of sheet 2.
Also assuming the full list of 1000 names is in column A of sheet 1.
Starting in cell B1:

=IF(COUNTIF(Sheet1!$A$1:$A$1000,A1)0,"","Alert")



"Steve" wrote:

I have 1000 names on sheet data 1! Column H
On sheet data 2! I have all the same names in Column H, except 2 are missing
( only 998 names)

Can I do a Vlookups in column Z of either/or both sheets that would show
what names are missing ? I'm trying to reconcile two differernt data sources.

Something like -- If same names are on both sheets,"", if Not "ALERT" or the
actual name would be ok too.

And vice-versa, if name on data 2! but not on data 1!

Much thanks,

Steve