Index match formula to match related data

Hi,
Please write a formula as per below details.

From the data table A3:G18 we need to fill the formula from L4:S28. There is no duplicate data in the range C4:G18 by each date.

Logical condition for L4 cell is if the cell K4 is matched in the range of C4:G18 and L3 cell is matched with A4:A18 then I need to find the related data from the column B4:B18 (Manager).

Thank u.

Hi,
Thanks for your response.
I copied the formula but it is working for the first column (D4:D18) only. It is not working for the data E14:E18.
Thank u.

Dear Bebo,
Thanks for your formula.
I have corrected the data range and now it is working for all the data.
Corrected Formula is
=IF(MAX(IF($C$4:$G$18=$K4,IF($A$4:$A$18=L$3,ROW($B$4:$B$18))))=0,"",INDEX($B:$B,MAX(IF($C$4:$G$18=$K4,IF($A$4:$A$18=L$3,ROW($B$4:$B$18))))))
Thank u so much.