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

Try the below formula in Sheet 'T' in a unused column (say G). The formula
will check whether the name in Sheet T cell E2 exists in SheetC col B..If it
is present the formula will return a blank and if present return the name
itself in ColG...copy down as required....

=IF(COUNTIF('C'!B:B,E2),"",E2)

If this post helps click Yes
---------------
Jacob Skaria


"Steve" wrote:

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

Thank you. Worked great. And a lot simplier/cleaner than I was expecting.

Thanks again,

Steve

"Jacob Skaria" wrote:

Try the below formula in Sheet 'T' in a unused column (say G). The formula
will check whether the name in Sheet T cell E2 exists in SheetC col B..If it
is present the formula will return a blank and if present return the name
itself in ColG...copy down as required....

=IF(COUNTIF('C'!B:B,E2),"",E2)

If this post helps click Yes
---------------
Jacob Skaria


"Steve" wrote:

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