as long as that date and type are static the way you have them, the formula will always return the same emplyee. perhaps if you included another column for the date and for the type, and then have your fomula based on that, it would work better for you?