vlookup a value for a certain date

[SColyn]

Good day,

Please assist, I would like to lookup a value for a certain date.

Below is a sample of my data. The one sheet will have the contract data e.g. Machine no, date, contract data (is machine in contract for the specific month)
[TABLE="width: 500"]
<tbody>[TR]
[TD]Machine No[/TD]
[TD]Date[/TD]
[TD]Contract[/TD]
[/TR]
[TR]
[TD]123567[/TD]
[TD]01.01.2018[/TD]
[TD]Yes[/TD]
[/TR]
[TR]
[TD]123456[/TD]
[TD]01.01.2018[/TD]
[TD]No[/TD]
[/TR]
[TR]
[TD]123567[/TD]
[TD]01.02.2018[/TD]
[TD]Yes[/TD]
[/TR]
[TR]
[TD]123456[/TD]
[TD]01.02.2018[/TD]
[TD]Yes[/TD]
[/TR]
</tbody>[/TABLE]

The other sheet will have data relating to our machines. I would like to add the contract data for the specific month to the sheet below.
[TABLE="width: 500"]
<tbody>[TR]
[TD][TABLE="width: 79"]
<tbody>[TR]
[TD="align: right"]Machine No[/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]
[/TD]
[TD]Machine Desc[/TD]
[TD]Date [/TD]
[TD]Machine Hours[/TD]
[/TR]
[TR]
[TD][TABLE="width: 79"]
<tbody>[TR]
[TD="align: right"]123567[/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]
[/TD]
[TD]Machine B[/TD]
[TD]01.01.2018[/TD]
[TD]1000[/TD]
[/TR]
[TR]
[TD][TABLE="width: 79"]
<tbody>[TR]
[TD="align: right"]123456[/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]
[/TD]
[TD]Machine C[/TD]
[TD]01.01.2018[/TD]
[TD]5000[/TD]
[/TR]
</tbody>[/TABLE]

 

[Special-K99]

What do you mean by "add the contract data" ?
There are no figures to add.

What's the significance of the Contract data?
It doesnt appear in the second table so how does it relate to the second table?

 

[SColyn]

My sample data my not be very clear.

I have one set of data showing the number of services we are suppose to do on a certain machine (Potential services) and the number of services we actually do (Completed services) with the hours of each machines. The hours are important as we have to do a service every 1000 hours. Then I have another set of data showing which of our equipment is in contract.

I have to report the machine services on contract seperately from the ones without a contract and the contract data can differ each month. Our contracts do not run from Jan to Dec, the contract might start in March and run for only 6 months. This is why I would like to include the contract data for the particular month. The contract data set already has the dates in it.