Comparing two sets of data, and outputting the matches to another location

[gobofraggle]

Hello. I have a problem I've been working on for a few days now, and
I can't seem to come up with a solution.

I have two columns of data. The first is a list of company employees
sorted by last name (about 10,000 names), followed by the department
they work in. The second is a sample list of the employees (about 200
names), also sorted by last name, and the computer systems access
level they have. What I want to do is compare the second list to the
first list, and where the names appear on both lists, output the data
from both columns (for that name) to a third location. The goal of
this process is to assure that users in certain departments have the
correct systems access status. Unfortunately, the data is being
pulled from two separate sources (the first is a simple employee list
from the HR department, while the second list is from the IT
department).

Any help would be greatly appreciated. Thank you in advance.

 

[Frank Kabel]

Hi
as a starting point:
http://www.cpearson.com/excel/duplicat.htm#ExtractingCommon

and afterwards use Data - Filter to get the appropiate rows

 

[gobofraggle]

I'm having some problems with those instructions. I don't understand
the line "
Change B1 and $A$1:$A$10 to the first cells in the ranges from which
data that you want to extract common items." I am sort of new to
this, so this is confusing. The data in my column A goes from
A1:A10000, and the data in my column B goes from B1:B250. How,
exactly, should I write the formula? Also, do the values have to be
EXACTLY the same (with regard to capitalization) for the formula to
work?

Also, I know that this must be an "array formula". How does this
differ from a regular formula?

Thanks again,
(e-mail address removed)