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.

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.

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.

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.

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.

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.

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.

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.

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.