| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
match dates in two columns get value from third
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need to match 2 columns, if a match found add info from 2nd column | Excel Worksheet Functions | |||
| match two columns (with equal dates) and their attached datasets | Excel Discussion (Misc queries) | |||
| help with sorting text in columns to match other columns | Excel Discussion (Misc queries) | |||
| Using MATCH with dates | Excel Worksheet Functions | |||
| How To Match Dates | Excel Discussion (Misc queries) | |||
Threaded Mode
