match dates in two columns get value from third

  • Thread starter Thread starter jaichander
  • Start date Start date
J

jaichander

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
 
Try this in D1:

=IF(ISNA(MATCH(A1,B:B,0)),"",VLOOKUP(A1,B:C,2,0))

Then copy down.

Hope this helps.

Pete
 
Back
Top