Try

M3=IF(AND(INDEX($B$2:$B$15,MATCH($L3,$A$2:$A$15,0))="",INDEX($A$2:$A$15,MATCH($L3,$A$2:$A$15,0))<>"",INDEX($F$2:$F$15,MATCH($L3,$A$2:$A$15,0))<>"",INDEX($H$2:$H$15,MATCH($L3,$A$2:$A$15,0))<>"",MATCH($J$3:$J$8,$D$2:$D$15,0)),INDEX($A$2:$H$15,MATCH($L3,$A$2:$A$15,0),(COLUMNS($Q$1:Q1)-1)*2+4),5) and drag towards the cell.