Pull information in one tab based on field in another tab.. HELP!

Hi! I have a work project I'm completing and am now stuck. I would appreciate any direction someone here can give me. Here is my situation:

I have a spreadsheet that contains 2 tabs

Tab1 - Contains 20,000 rows listing each employee of our organization and information about this employee (i.e. employee number, name, position info, site etc). Column A holds the "cost center" that each employee is paid out of.

Tab2 - Contains a list of 202 departments that are part of one large portfolio and therefore grouped under one director, but have various managers>supervisors>coordinators (differente columns contain this information). Column A holds the "cost center" number that belongs to each individual department

I need to create a list of all employee listed in Tab 1 that are associated to the cost centers listed in Tab 2.

Clear as mud? I am sure Excel has a way to do this that is easier than me looking in Tab 2, filtering Tab 1 and then cutting and pasting out of it into a new blank tab.

Any help someone can give me would be appreciated!!
Jana

JanaA,

Take a look at the attachment and see if it gives you any ideas. Considering the amount of data you're dealing with, it can also be done with a non array formula and a helper column. Take a look and come back if you have questions.

Dean