Exceed a 3 year period from a specific date

[david gabra]

Hello

Background:The excel has 2 tabs:
#tab 1) a table showing employee number and the name of months employed and the allowance the employee is entitled to per month.
#tab 2) A table showing when the employee became an expat.

Entitlement End Criteria: 3 years after the date the employee became an expat

Requirement:
I would like excel to show on sheet 1 the months (tab #1) the employee is No Longer eligible

Model excel added to show desired outcome, when using excel logic.

Thank you very much

Dave.

 

[Chihiro]

Try...
=IF(B2>(EDATE(INDEX('Position Change'!$C$2:$C$3,MATCH(A2,'Position Change'!$A$2:$A$3,0)),12*3)),"No","Yes")

Copy down.

 

[david gabra]

Perfect!!!!!!!
Thank you so much.