matching data to dates - please help "Marty" <martp[ at ]blueyonder.co.uk> 12/31/2008 5:25:57 PM 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.

RE: matching data to dates - please help Shane Devenshire 12/31/2008 5:37:02 PM 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: [Quoted Text] > 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. > > >

Re: matching data to dates - please help "Marty" <martp[ at ]blueyonder.co.uk> 12/31/2008 5:45:01 PM 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" <ShaneDevenshire[ at ]discussions.microsoft.com> wrote in message news:B9DF7FC5-A85D-44E3-AC20-2CACA4E949FE[ at ]microsoft.com... [Quoted Text] > 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. >> >> >>

Re: matching data to dates - please help Mike H 12/31/2008 5:59:00 PM Marty, Shane meant =IF(ISNA(VLOOKUP(A1,D$1:E$100,2,0)),"",VLOOKUP(A1,D$1:E$100,2,0)) "Marty" wrote: [Quoted Text] > 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" <ShaneDevenshire[ at ]discussions.microsoft.com> wrote in > message news:B9DF7FC5-A85D-44E3-AC20-2CACA4E949FE[ at ]microsoft.com... > > 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. > >> > >> > >> > > >

Re: matching data to dates - please help "Marty" <martp[ at ]blueyonder.co.uk> 12/31/2008 6:12:17 PM Excellent, that did it. I don't have a Yes button though? "Mike H" <MikeH[ at ]discussions.microsoft.com> wrote in message news:F4B0CB7F-57F7-4069-9C99-03BF38B20B7A[ at ]microsoft.com... [Quoted Text] > Marty, > > Shane meant > > =IF(ISNA(VLOOKUP(A1,D$1:E$100,2,0)),"",VLOOKUP(A1,D$1:E$100,2,0)) > > "Marty" wrote: > >> 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" <ShaneDevenshire[ at ]discussions.microsoft.com> wrote in >> message news:B9DF7FC5-A85D-44E3-AC20-2CACA4E949FE[ at ]microsoft.com... >> > 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. >> >> >> >> >> >> >> >> >>

Re: matching data to dates - please help Shane Devenshire 12/31/2008 6:41:03 PM Hi, Lost that second ) sorry. -- If this helps, please click the Yes button Cheers, Shane Devenshire "Marty" wrote: [Quoted Text] > 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" <ShaneDevenshire[ at ]discussions.microsoft.com> wrote in > message news:B9DF7FC5-A85D-44E3-AC20-2CACA4E949FE[ at ]microsoft.com... > > 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. > >> > >> > >> > > >