Dera "silambarasan.J", You can also do this. Refer attach file.
In timesheet : Add helper column "C" with formula
Formula:
=YEAR(A2)&" "&(B2)
copy down.
In payslip sheet : in "D2"
Formula:
=IF(COUNTIF('TIME SHEET'!$C$2:$C$378,PAYSLIP!$B$2&" "&PAYSLIP!$B$3),MIN(IF('TIME SHEET'!$C$2:$C$378=PAYSLIP!$B$2&" "&PAYSLIP!$B$3,'TIME SHEET'!$A$2:$A$378)),"")
In "D3"
Formula:
=IF(COUNTIF('TIME SHEET'!$C$2:$C$378,PAYSLIP!$B$2&" "&PAYSLIP!$B$3),MAX(IF('TIME SHEET'!$C$2:$C$378=PAYSLIP!$B$2&" "&PAYSLIP!$B$3,'TIME SHEET'!$A$2:$A$378)),"")
[Array formula, use Ctrl-Shift-Enter]
Bookmarks