Column A:A contains chronological dates.
Column B:B contains values pertaining to column A:A.
Column C:C contains recurring dates.
I'd like the values of column B placed in column D next to the corresponding C column dates.
A B C D
19/08/2000 £100.00 19/08/2000 £100
20/08/2000 £102.45 19/08/2000
21/08/2000 £107.45 19/08/2000
22/08/2000 £107.45 19/08/2000
23/08/2000 £112.60 19/08/2000
24/08/2000 £112.60 19/08/2000
25/08/2000 £112.60 19/08/2000
26/08/2000 £112.60 20/08/2000
27/08/2000 £112.60 20/08/2000
So the formula for cells D1:D7 would return £100.
Then the formula for cells D8:D9 would return £102.45.
... and so on.
Any input welcome.
Apologies for the lack of format. Not really that good with the forum yet, and had trouble posting the excel file.
I think it pretty easy to gather what my aim is anyhow.
Thanks for viewing.
Bookmarks