Comparing 2 Excel Lists and Appending if entries are in both

[richard.karesh]

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.

 

[vezerid]

There are several tests for set membership. One is using the COUNTIF()
function:

=IF(COUNTIF(_list_, A2)=1, "Employee", "Contractor)

In place of _list_ you would put something like G:G (for an entire
column in the same list) or Sheet1!G:G (in another sheet) or 'Employee
List'!G:G (for other sheets whose names contain spaces)

HTH
Kostis Vezerides

 

[richard.karesh]

Thanks. I believe this will fit the bill.

 

[richard.karesh]

Thanks. I believe this will fit the bill.