Formula which can fetch percent between two dates

[Amit Punia]

Need a formula which can fetch a percentage based on a date(Which is between two dates).

Please find the attached file for the data. Need formula in cell C6 which can be copied horizontally till V6. Basically this formula should check if the dates from range F10:F20 is coming under dates between C2 and C4. If yes, it should show the respective percentage next to month column.

Thanks in advance

 

[vletm]

Amit Punia
=IFERROR(LOOKUP(C2,$E10:$E21,$F10:$F21),"")

 

[Amit Punia]

@vletm If you put the formula in the sheet, it is not taking the data based on the dates mentioned in the range E10:E20.
I updated the formula you have given and 1st date is 01-Jun-18 and against that 10% is there. So if we update the formula in cell C6 then it should show 10% because June-18 comes between April-18(Cell C2) and June-18(Cell C4).

The formula should fetch the percentage based on the date mentioned in range E10:E20 which are between C2 and C4.

 

[vletm]

Amit Punia
I had that formula in the sheet ...

Which value would come to 'C6'?
Could You name it?

 

[Amit Punia]

See in your image, percentage against 30-Oct(Cell E11) is 8%. October comes between date range "Oct-18 & Dec-18". So it should be updated in cell E6. Your image is showing 10% in E6.

 

[Naresh Yadav]

Dear Amit,

Pls try and see if this works for you

=SUMIFS($F$10:$F$20,$E$10:$E$20,">="&C$2,$E$10:$E$20,"<="&C$4)

regards
Naresh

 

[Amit Punia]

Yes, It's working absolutely fine now. Thanks a lot @Naresh Yadav.

 

[vletm]

Amit Punia
There were TYPO 2 -> 4 ...
=IFERROR(LOOKUP(C4,$E10:$E21,$F10:$F21),"")

Those would be 'better' test values or how?