Lookup Formula

[Kumar Chandra]

Please help me below. Hope someone can help me,

I have two workbook like below:
Workbook 1 As below:

S.No	Name	Leave Start	Leave End		Total Days	Leave Type
1	AA	01-Jan-17	04-Jan-17	FALSE	4	Annual Leave
2	B	08-Jan-17	11-Jan-17	FALSE	4	Annual Leave
3	AA	15-Jan-17	18-Jan-17	FALSE	4	Sick Leave
4	AA	21-Jan-17	22-Jan-17	FALSE	2	Annual Leave
5	B	28-Jan-17	05-Feb-17	FALSE	9	Sick Leave

<colgroup><col width="72" style="width: 54pt;"> <col width="83" style="width: 62pt; mso-width-source: userset; mso-width-alt: 2656;" span="5"> <col width="112" style="width: 84pt; mso-width-source: userset; mso-width-alt: 3584;"> <tbody> </tbody>

Workbook 2 Dates are in DD format

	Date 1-jan to 27 Jan
Name	01	02	03	04	05	06	07	08	09	10	11	12	13	14	15	16	17	18	19	20	21	22	23	24	25	26	27
AA	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1
B	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1

<colgroup><col width="77" style="width: 58pt; mso-width-source: userset; mso-width-alt: 2464;"> <col width="29" style="width: 22pt; mso-width-source: userset; mso-width-alt: 928;" span="27"> <tbody> </tbody>

I want result as below (AL= Annual Leave, SL = Sick Leave...)

	Date
Name	01	02	03	04	05	06	07	08	09	10	11	12	13	14	15	16	17	18	19	20	21	22	23	24	25	26	27
AA	AL	AL	AL	AL	1	1	1	1	1	1	1	1	1	1	SL	SL	SL	SL	1	1	AL	AL	1	1	1	1	1
B	1	1	1	1	1	1	1	AL	AL	AL	AL	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1

<colgroup><col width="77" style="width: 58pt; mso-width-source: userset; mso-width-alt: 2464;"> <col width="29" style="width: 22pt; mso-width-source: userset; mso-width-alt: 928;" span="27"> <tbody> </tbody>

Thank you

 

[Kumar Chandra]

:D , No one can answer?, I thought, I can get answer here

 

[Kumar Chandra]

Crazy, No one replied: Finally I got answer after 3 Days.

=IFERROR(IF(INDEX($G$19:$G$24,MATCH(1,($C$19:$C$24<=N$6)*($D$19:$D$24>=N$6)*($B$19:$B$24=$M37),0))="Annual Leave","AL",IF(INDEX($G$19:$G$24,MATCH(1,($C$19:$C$24<=N$6)*($D$19:$D$24>=N$6)*($B$19:$B$24=$M37),0))="Sick Leave","SL","")),1)