match dates in two columns get value from third
Try this in D1:
=IF(ISNA(MATCH(A1,B:B,0)),"",VLOOKUP(A1,B:C,2,0))
Then copy down.
Hope this helps.
Pete
On Dec 17, 7:59*am, jaichander
wrote:
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
|