Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
matching data to dates - please help
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
matching data to dates - please help
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
matching data to dates - please help
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" 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. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
matching data to dates - please help
Excellent, that did it.
I don't have a Yes button though? "Mike H" wrote in message ... 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" 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. |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
matching data to dates - please help
Hi,
Lost that second ) sorry. -- If this helps, please click the Yes button Cheers, Shane Devenshire "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" 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. |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
matching data to dates - please help
No problem, I don't have a Yes button to click on though? Using Outlook
Express 6? "Shane Devenshire" wrote in message ... Hi, Lost that second ) sorry. -- If this helps, please click the Yes button Cheers, Shane Devenshire "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" 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. |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
matching data to dates - please help
Ignore the bit about the Yes button. There are a a number of people on the
newsgroup who seem to assume that everyone is using the strange (and unreliable) Microsoft web interface to the newsgroup. Those of us who access the newsgroup directly have to learn to ignore these frustrating requests to use a non-existent button. -- David Biddulph Marty wrote: No problem, I don't have a Yes button to click on though? Using Outlook Express 6? "Shane Devenshire" wrote in message ... Hi, Lost that second ) sorry. -- If this helps, please click the Yes button Cheers, Shane Devenshire "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" 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. |
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
matching data to dates - please help
Thanks David, it wasn't something I'd seen in other newsgroups.
"David Biddulph" <groups [at] biddulph.org.uk wrote in message ... Ignore the bit about the Yes button. There are a a number of people on the newsgroup who seem to assume that everyone is using the strange (and unreliable) Microsoft web interface to the newsgroup. Those of us who access the newsgroup directly have to learn to ignore these frustrating requests to use a non-existent button. -- David Biddulph Marty wrote: No problem, I don't have a Yes button to click on though? Using Outlook Express 6? "Shane Devenshire" wrote in message ... Hi, Lost that second ) sorry. -- If this helps, please click the Yes button Cheers, Shane Devenshire "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" 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Matching dates | Excel Discussion (Misc queries) | |||
Matching identical data using data only once in the matching proce | Excel Discussion (Misc queries) | |||
macro paste by matching dates | Excel Discussion (Misc queries) | |||
Matching data and linking it to the matching cell | Links and Linking in Excel | |||
Matching 2 "dates" that are formated differently | Excel Worksheet Functions |