What formula for timeplan milestone allocation?

Hi All,

I am trying to build a tool but there is one function I am unable to wrap my head around. I was hoping for some help from your end.

Underneath you can find a simple reflection of what I am trying to do. We have a table with milestones in there.

Next we have a timeline which I want to show the milestones in the month reflected to the dates in the table. (the bottom section shows what I want)

obviously adding the percentages is an easy Vlookup based on the milestone names but how do I manage to get the milestone names in the right fields?

Any suggestions are welcome - I am trying to not use VBA or macro's