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