Thread: Matching one dates column with another and returning a value

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.

Hello,

on the premise that the data starts in cell A1, you could use in D1 and copy down

=vlookup(c1,$a$1:$B$1000,2,false)

Adjust ranges to suit.

cheers,

Have you considered using VLOOKUP?