Trying to make my formula also use the date for placement of data

[opattison]

After some great help here i have another query about this formula I'm trying to do.

what I'm trying to achieve is an automated filler which is currently in place and working, however I'd like to know if it is possible to match the date so that it will place the value across the date range rather than what it currently does and just places it in the first date each time.

See attached
examplebook.xlsx

any help would be appreciated

Thank you

[Special-K]

Try this

in H3
=IF(ISNA(MATCH(H$2,$A$3:$A$6,0)),"",INDEX($A$3:$D$6,MATCH(H2,$A$3:$A$6,0),4))

and copy across the columns to AC3

[opattison]

Potentially this is what i am looking to do with matching the date range however, with this formula it has lost a key element of the formula i was using before which would spread the broken down weekly price across the specified duration:

=IF(COUNTA($H$2:H$2)>$C3,"",$D3)

what i think i need is a cross of the two formulas that spreads the data at the same time as matching the date, do you have any solutions for this?

Regards.