Use this on SheetA:

=IF(ISNA(MATCH(B2,SheetB!G:G,0)),"not present on B","")

and copy down, then use this on SheetB:

=IF(ISNA(MATCH(G2,SheetA!B:B,0)),"not present on A","")

and copy this down.

In each sheet you know the names that are on that sheet, so you just
want to know which of them are not on the other sheet.

I've assumed that your data starts in row 2 on both sheets - adjust B2
and G2 if necessary.

Hope this helps.

Pete

On Oct 3, 9:50*pm, Steve wrote:
I have two differnt source files for employees on two different tabs. Both
tabs have their ID #:
On sheet A it's in the B column.
B * * * * * * C
123 * * * *Sam

On sheet B it's on the G columm.

G * * * * * * H
* * * * * * * * * *(Sam's ID & name are not on Sheet B)

The row locations are different, meaning one week Sam's ID may be in A16, and
the next week in A20. Same with sheet B.

What formula could I use on sheet A *to identify if an employee is on A but
not B, and on sheet B, if an employee is on B but not A ? Like if found on A
but not on B, produce the name (Sam) *which is in the a column next to the
ID# ( column C in sheet A).

I hope this makes sense.

Much thanks,

Steve