Can anyone help. I have a spreadsheet that has worked up until today. On tab Student Worker Pay Column F, it is supposed to look at certain variables and compare them tab Student Worker List. It was working fine until I had to have a duplicate entry on Student Worker List but with different dates. If the name, dept, and title match and the dates fall with within the dates listed on the Pay spreadsheet for that employee, it should bring back "A" otherwise "I". Samantha was hired during one period of dates and was rehired for new dates. Since the Name, Dept, and Title are the same for both, the formula isn't bring back the correct data.

Any suggestions????

12-13 student Test.xlsx