Calendar to bring the Leave Type from Leave Data to Calendar

[sethu29]

Hi Support,


I've two Sheets. Sheet one (Employee Details) with Date as Header. I'm using this as calendar.... I would like to bring the Leave Type from Data Sheet to Employee Details Sheet.


1) Criteria 1- Only Approved Request (Status)
2) Criteria 2- Name match with Employee Name for the particular Date available in Employee Details Sheet
3)Criteria 3 - Within Start Date and End Date

Example Output below

Date	6/1/2020	6/2/2020	6/3/2020
Employee1	PL	CL	CL
Employee2	CL	CL	CL
Employee3	CL	CL	CL

Please help as this is very urgent

If no Leave , then leave it blank
Thank you
Sethu