Hi. I need a little assistance. I am trying to develop a formula to
append an indicator to a row of data if there is a match. I have 2
lists of data - one is all of the employees of company and the other is
a list of a department's members - both employees and contractors. I
need to identify and append an indicator of those who are employees.
There will be an exact match on names.

The Employees list - is 1 column of Names
The Department list - is a small database in excel with the following 4
fields:
Name
Address
Month
Hours Worked
( Status)

What I want to do, if if the Name on the Department list is also on the
Employee list, I would like to append a fifth field to the record
(called Status) with the Indicator of Employee, else Contractor in the
Department List.

I am trying to do this as elegantly as possible.

Thanks to all who are willing to help.