matching data to dates - please help
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.
"Shane Devenshire" wrote in
message ...
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.
|