Hi,

Try

=IF(ISNA(VLOOKUP(A1,D$1:E$100,2,0),"",VLOOKUP(A1,D $1:E$100,2,0))

Enter this in C1 and copy it down.
--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Marty" wrote:

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.