Correction in Array formula

[jack999]

Maybe it's a delimiter problem. You probably have US settings. I use Non-US settings.
My delimiter is a semicolon (if that's the problem, sorry, it's my fault I didn't change the delimiter).
Please see the attached file.

Please check the date in the blank cells

 

[jack999]

Maybe it's a delimiter problem. You probably have US settings. I use Non-US settings.
My delimiter is a semicolon (if that's the problem, sorry, it's my fault I didn't change the delimiter).
Please see the attached file.

 

[navic]

To remove a result if a cell is empty, the formula needs to be nested in the IF function, with one condition.

=IF(D4="","",IF(COUNTIFS(DATA2!$E:$E,$B4,DATA2!$H:$H,$C4,DATA2!$B:$B,$D4)<1,"",INDEX(DATA2!C:C,SMALL(IF((DATA2!$E$2:$E$340=$B4)+(DATA2!$H$2:$H$340=$C4)+(DATA2!$B$2:$B$340=$D4)=3,ROW(DATA2!$B$2:$B$340)),1))))

I'm sorry, but I have no more time for you. I'm going on my vacation.

 

[jack999]

To remove a result if a cell is empty, the formula needs to be nested in the IF function, with one condition.

=IF(D4="","",IF(COUNTIFS(DATA2!$E:$E,$B4,DATA2!$H:$H,$C4,DATA2!$B:$B,$D4)<1,"",INDEX(DATA2!C:C,SMALL(IF((DATA2!$E$2:$E$340=$B4)+(DATA2!$H$2:$H$340=$C4)+(DATA2!$B$2:$B$340=$D4)=3,ROW(DATA2!$B$2:$B$340)),1))))

I'm sorry, but I have no more time for you. I'm going on my vacation.

Thank you for your help and time you have spend for me. May God bless you. Happy Vacation.