Return Corresponding Data For Each Occurence...

I need help in writing an excel formula that will lookup each occurance of a value in one range and return the corresponding value in another range based on specified criteria.

I have attached a sample file. What I need the formula to do is lookup the value in Column A on 'EE Data Sheet' (which has multiple occurances of the same value) and give me the corresponding value in Column E (ID #) only if the date in Column K (Service Dt) is greater than 7/21/2008. The return value needs to be on the '151_SD Sheet'.

In other words, I need the ID number from Column E on the 'EE Data Sheet' returned to me on Sheet 151_SD for each occurrance of 1806-151 (Column A on EE Data Sheet) only if the date in column K is greater than 7/21/2008. The areas highlighted in yellow show the data to be returned on the 151-SD sheet.

I tried vlookup & match and hlookup & match, but I only got the first occurance of 1806-151.

Re: Find Multiple Occurances In Range And Return Corresponding Value

I have over 1500 combination codes of the OU / FA located in column A with a multitude of data attached to the ID# needed. A pivot will expand and contract each month with adds, deletions and transfers. I need something flexible.

Re: Return Corresponding Data For Each Occurence...

My objective is to track headcount activity across multiple departments across multiple operating units by month. If an ID disappears I need to know if it was a termination or transfer. I have a specific format setup for this, hence my need for your help. The format includes ID#s and associated data that was budgeted at a specific point in time (7/21/08). I have to track by month where everybody is. The pivot picks up every single day of activity in the data dump for each month, making the spreadsheet humongous.