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.