I have names in worksheets E & T. Mosdt names are in bith sheets, though some
that are in E are not in T.

I have this formula in the H column of worksheet A.

IF('C'!E20,VLOOKUP('C'!E2,'T'!$B$3:$I$700,2,FALSE ),"")
It produces either names from Worksheet C if employee found in E2 is also
found in worksheet T, or #N/A if they're not found in Worksheet T.

I'd like to have a formula in the K column of worksheet A that will produce
the name of the employee from worksheet C that is NOT FOUND in worksheet T.
And if an employee is found in both worksheets, then nothing "" in that cell
in the K column.

Something like: If names on both sheets, "", if not, "Smith".

I hope this makes sense.

Thanks,

Steve