vlookup help

[Amine008]

Hey guys,

I'm new here in your forum and need a quick help to solve one issue that I'm facing.
In the below, I want a formula to see if the badge id was present in the date (Culmn H) or off in this date.

Thanks for your help.

A B C D G H I

Badge	From Date	To Date	Attendance		Badge	Date	Attendance
1234	16/12/2016	19/12/2016	Absent			1234	17/12/2016	Here I want to see if badge id is present or off this day
1235	19/12/2016	20/12/2016	Holiday			1235	17/12/2016	Here I want to see if badge id is present or off this day
1236	20/12/2016	21/12/2016	Holiday			1236	17/12/2016	Here I want to see if badge id is present or off this day
1237	21/12/2016	22/12/2016	Absent			1237	17/12/2016	Here I want to see if badge id is present or off this day
1238	22/12/2016	23/12/2016	sick			1238	17/12/2016	Here I want to see if badge id is present or off this day
						1234	18/12/2016	Here I want to see if badge id is present or off this day
						1235	18/12/2016	Here I want to see if badge id is present or off this day
						1236	18/12/2016	Here I want to see if badge id is present or off this day
						1237	18/12/2016	Here I want to see if badge id is present or off this day
						1238	18/12/2016	Here I want to see if badge id is present or off this day

<colgroup><col><col span="2"><col span="4"><col><col></colgroup><tbody>
</tbody>

 

[Amine008]

Yes -- by adding two INT's. Here is an updated formula:

=IF(AND(H2>=INT(INDEX(B:B,MATCH(G2,A:A,0))),H2<=INT(INDEX(C:C,MATCH(G2,A:A,0)))),INDEX(D:D,MATCH(G2,A:A,0)),"Present")

Thanks a lot issue resolved. The stress on me was enormous ..
Many thanks for your help appreciate all support

 

[Tetra201]

You are welcome.