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

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.

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.

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.

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.

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.

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.