matching data to dates - please help

  • Thread starter Thread starter Marty
  • Start date Start date
M

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.
 
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.
 
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.
 
Back
Top