Find a value based on dates

[laxmaster3000]

Hi Everyone,

I'm trying to find a way to pull data values from one sheet and enter them into a table on another sheet.

For example, on May 1st 2018 100% of a job is completed:

[TABLE="width: 188"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]01-May-18[/TD]
[TD]100%[/TD]
[/TR]
[TR]
[TD]27-Apr-18 [/TD]
[TD]98.75% [/TD]
[/TR]
[TR]
[TD]26-Apr-18[/TD]
[TD]93%[/TD]
[/TR]
[TR]
[TD]10-Apr-18 [/TD]
[TD]83% [/TD]
[/TR]
[TR]
[TD]01-Apr-18 [/TD]
[TD]75%[/TD]
[/TR]
[TR]
[TD]15-Mar-18[/TD]
[TD]50%[/TD]
[/TR]
[TR]
[TD]01-Mar-18[/TD]
[TD]20%[/TD]
[/TR]
[TR]
[TD]01-Feb-18[/TD]
[TD]5%[/TD]
[/TR]
</tbody>[/TABLE]

I want to set up another table that shows month to month progress for various projects:

[TABLE="width: 360"]
<colgroup><col width="72" span="5" style="width:54pt"> </colgroup><tbody>[TR]
[TD="class: xl65, width: 72"]Start[/TD]
[TD="class: xl65, width: 72"]90 Days[/TD]
[TD="class: xl65, width: 72"]60 Days[/TD]
[TD="class: xl65, width: 72"]30 Days[/TD]
[TD="class: xl65, width: 72"]Finish[/TD]
[/TR]
[TR]
[TD="class: xl66"]0%[/TD]
[TD="class: xl66"]5%[/TD]
[TD="class: xl66"]20%[/TD]
[TD="class: xl66"]75%[/TD]
[TD="class: xl66"]100%[/TD]
[/TR]
</tbody>[/TABLE]

How can I get these numbers using a formula?

Thanks for the help!

 

[Special-K99]

If you want month to month progress you should stick with the month dates (01-Feb-18, 01-Mar-18, 01-Apr-18, etc) and not have 30 60 90 days.
That way you can just use a simple VLOOKUP to return the percentage if there is always an entry for the 1st of the month.

Let's do it your way: 01-May-18 minus 90 days is NOT 01-Feb-18, it's 31-Jan-18.
You have no percentage for 31-Jan-18 in your table.

 

[laxmaster3000]

Yes that's what I ended up doing, I standardized the dates reporting progress and used vlookup

Thanks!