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)
<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.
<tbody>
</tbody>
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.
<tbody> </tbody><colgroup><col></colgroup> | Machine Desc | Date | Machine Hours | |
<tbody> </tbody><colgroup><col></colgroup> | Machine B | 01.01.2018 | 1000 | |
<tbody> </tbody><colgroup><col></colgroup> | Machine C | 01.01.2018 | 5000 |
<tbody>
</tbody>