matching data to dates - please help

[Marty]

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.

 

[Shane Devenshire]

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.

 

[Marty]

Many thanks Shane, I just tried it and it said the formula contains an error
with the two speech marks in the middle?
I tried changing it (adding a comma etc) and still couldn't get it to work.

Please can you advise?

Thanks again for your help.

 

[Mike H]

Marty,

Shane meant

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

 

[Marty]

Excellent, that did it.

I don't have a Yes button though?

 

[Shane Devenshire]

Hi,

Lost that second ) sorry.

 

[Marty]

No problem, I don't have a Yes button to click on though? Using Outlook
Express 6?

 

[Marty]

Thanks David, it wasn't something I'd seen in other newsgroups.