Please have a look at the picture I attached, it'll make understanding my problem easier because it's hard to describe.

In the first table, I have capacity data for a product. The capacity changes by the date indicated in the column, i.e. from July 2017 the capacity would be 56, from December 2018 78, and from October 2019 99. The reason why I don't write down the capacity for every month is that I want to save columns.

In the second table, I have every month. I want to reference the correct capacity for each month, e.g. it would be 56 for every month until December 2018.

I have been considering an =INDEX function, but it seems to complex for that. Is there a way to reference like this without using VBA? Would the VBA solution be simple? Or am I forced to write a column for every month's capacity in the first table? Thank you!
<https://i.imgur.com/mRoBtTo.png>
![Capacity Problem](https://i.imgur.com/mRoBtTo.png)