I have a data set on daily basis and another data set on weekly basis. i want
to put the weekly data in daily data set by putting a formula which picks
values from col c for relevant dates in daily set. example - let us say this
is the data set

ColA Col B Col C
jan1 jan1 8
jan2 jan7 7
jan3
jan4
jan5
jan6
jan7

I want the data from colC against dates in ColA as in ColD below. it should
leave other cells blank (colA and ColB are dates format)
ColA Col B Col C ColD
jan1 jan1 8 8
jan2 jan7 7
jan3
jan4
jan5
jan6
jan7 7

Kindly suggest a formula