Hi all,

I'm having trouble finding the best way of acheiving this, hoping someone
can advise.

In column A I have a date range of 1/2/07 to present
In column B I have data corresponding to column A
In column D I have dates on odd days between 1/2/07 to present
In column E I have data corresponding to column D.

I want to have the data in column E in column C where the date in column A
matches a value in column D.

For example, cell A5 matches D2, therefore in C5 I want the value in E2
cell A12 matches D3, therefore in C12 I want the value in E3.

Can anyone help please? I want the other cells in column C to be empty.