match dates in two columns get value from third

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
 
P

Pete_UK

Try this in D1:

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

Then copy down.

Hope this helps.

Pete
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top