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)

Machine No	Date	Contract
123567	01.01.2018	Yes
123456	01.01.2018	No
123567	01.02.2018	Yes
123456	01.02.2018	Yes

<tbody>
</tbody>

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.

Machine No <tbody> </tbody><colgroup><col></colgroup>	Machine Desc	Date	Machine Hours
123567 <tbody> </tbody><colgroup><col></colgroup>	Machine B	01.01.2018	1000
123456 <tbody> </tbody><colgroup><col></colgroup>	Machine C	01.01.2018	5000

<tbody>
</tbody>

 

[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.