Comparing Employee IDs accross two Sheets

So I work for one of the largest insurance companies in the United states and work on reporting. I am currently working on a report based upon employees and have run into a bit of a..... problem. I have turned to the Excel forums for some help and hope you guys can provide a solution. First of all, thank you to any who can provide any help whatsoever.

I have two reports, one report consists of employee IDs for a single department within our company. The Other report consists of all tickets handled by our Help Desk. The second report has all employee IDs regardless of the department they work in. There is no way, to simply filter out the alias of a certain department in the second report so I need to find some way of isolating just this one department. These employee IDs are four characters long and can consist of numbers and letters. They always start with a letter.

I was wondering if anyone was aware of a "workflow" or Forumla that I could use to accomplish this? To break it down even further. I Have a list of data that contains say 4000 employee IDs (second report), and I only want to see that data for the 500 some IDs (first report) in this one specific department. There are other fields of data tied to the 4000 IDs that I want to view for just the 500 IDs. I know there is a workaround for this, I Just cant seem to find it via google or any of my references.

Please let me know if there is any other information I need to provide or if I can clarify my purpose here. Thank you to any and all who are willing to help.

Best Regards,

SirNeiko

assuming ID in column A on sheet2 and column A on Sheet1 (the first report). an additional formula column using:
=ISNUMBER(MATCH(A2,Sheet1!A:A,0))
will return TRUE for numbers that match the department list and FALSE for others. you can then filter on that column.

Hello SirNeiko, and welcome to the forum.

Thanks for amending your title.

in Sheet1 cell AD2
=ISNUMBER(MATCH(AC2,Sheet2!B:B,0))

since you are on 2010 you could also simply create tables from both sheets and load them both into powerpivot then create a relationship on the ID column.

it's an add-in. you can get it from here: http://www.microsoft.com/en-us/bi/powerpivot.aspx