Attendance Tracker

[Arup Dutta Chowdhury]

Hi,
I have got a excel file which has two sheets. Sheet 1 is attendance sheet and sheet 2 score sheet. First sheet will capture the attendance as Present who have got marks in score sheet and others as absent who hasn't got any marks means zero or blank in the second sheet. Please help.

 

[bosco_yip]

Maybe,

In "Attendance Tracker" sheet E2, copied down :

=IF(ISNUMBER(MATCH(1,INDEX(('L1- Score Card'!B$1:B$1000=B2)*('L1- Score Card'!D$1:D$1000>0),0),0)),"present","absent")

Regards
Bosco

 

[Arup Dutta Chowdhury]

Thanks Bosco