this may be a similar post to one entered recently but i desperately need
some help with a formula. i have 2 variables each with 3 options. For each of
the 9 possible combinations i need a different answer. this is to do with
employee leave and is dependent on their paypoint and length of service.
less than 5 YRS hit 5 years btwn 5+ YEARS@01/04/08
@01/04/07 01/04/07&01/04/08

4 - 21 20 0 25
22 - 28 21 0 25
29 - 40 23 0 26

i have the list of paypoints stored in E column and list of date they hit 5
yrs service in column J.
if anyone could provide me with a formula - i have tried and failed with IF
& AND functions - or let me know if i can do it a different way i would be
really grateful!!
thanks in advance!