Formula falling over in more than one cell
 

Hi, hope you can help me.
I'm trying to import information from one worksheet into a calendar -
if the date value fits, then info from cells on the same line should be
imported to the calendar page.

This formula
=IF(Sheet1!B:B=DATE(2006,5,30), CONCATENATE(Sheet1!D:D," ",
Sheet1!E:E," ", Sheet1!H:H," ", Sheet1!I:I, " ")," ")

works brilliantly, but only as that one function, if I change the date
to a previous or later one, I don't get a return value.
The formula isn't coming up with an error, but there's obviously
something going on that Excel doesn't like.

Any ideas?


--
moviegrrl
------------------------------------------------------------------------
moviegrrl's Profile: http://www.excelforum.com/member.php...o&userid=34790
View this thread: http://www.excelforum.com/showthread...hreadid=545462

Formula falling over in more than one cell
 

Are you sure that the other date actually exists within the data?

--
HTH

Bob Phillips

(replace somewhere in email address with googlemail if mailing direct)

"moviegrrl" wrote
in message ...

Hi, hope you can help me.
I'm trying to import information from one worksheet into a calendar -
if the date value fits, then info from cells on the same line should be
imported to the calendar page.

This formula
=IF(Sheet1!B:B=DATE(2006,5,30), CONCATENATE(Sheet1!D:D," ",
Sheet1!E:E," ", Sheet1!H:H," ", Sheet1!I:I, " ")," ")

works brilliantly, but only as that one function, if I change the date
to a previous or later one, I don't get a return value.
The formula isn't coming up with an error, but there's obviously
something going on that Excel doesn't like.

Any ideas?


--
moviegrrl
------------------------------------------------------------------------
moviegrrl's Profile:
http://www.excelforum.com/member.php...o&userid=34790
View this thread: http://www.excelforum.com/showthread...hreadid=545462

Formula falling over in more than one cell
 

Absolutely!
For each month I have a set of specific dates - they are all listed on
the Sheet that I'm trying to work with, they are all in correct date
formula and all I'm doing is copying the formula and changing the date
but with no luck.


Bob Phillips Wrote:
Are you sure that the other date actually exists within the data?

--
HTH

Bob Phillips

(replace somewhere in email address with googlemail if mailing direct)

"moviegrrl"
wrote
in message
...

Hi, hope you can help me.
I'm trying to import information from one worksheet into a calendar
-
if the date value fits, then info from cells on the same line should
be
imported to the calendar page.

This formula
=IF(Sheet1!B:B=DATE(2006,5,30), CONCATENATE(Sheet1!D:D," ",
Sheet1!E:E," ", Sheet1!H:H," ", Sheet1!I:I, " ")," ")

works brilliantly, but only as that one function, if I change the
date
to a previous or later one, I don't get a return value.
The formula isn't coming up with an error, but there's obviously
something going on that Excel doesn't like.

Any ideas?


--
moviegrrl

------------------------------------------------------------------------
moviegrrl's Profile:
http://www.excelforum.com/member.php...o&userid=34790
View this thread:
http://www.excelforum.com/showthread...hreadid=545462



--
moviegrrl
------------------------------------------------------------------------
moviegrrl's Profile: http://www.excelforum.com/member.php...o&userid=34790
View this thread: http://www.excelforum.com/showthread...hreadid=545462

Formula falling over in more than one cell
 

Any chance that some of your dates may be text that looks like a date?

I'd one of the cells that looks like it should work (but doesn't) as a date.
Then reenter that date.

==
Any chance your dates include time?



moviegrrl wrote:

Absolutely!
For each month I have a set of specific dates - they are all listed on
the Sheet that I'm trying to work with, they are all in correct date
formula and all I'm doing is copying the formula and changing the date
but with no luck.

Bob Phillips Wrote:
Are you sure that the other date actually exists within the data?

--
HTH

Bob Phillips

(replace somewhere in email address with googlemail if mailing direct)

"moviegrrl"
wrote
in message
...

Hi, hope you can help me.
I'm trying to import information from one worksheet into a calendar
-
if the date value fits, then info from cells on the same line should
be
imported to the calendar page.

This formula
=IF(Sheet1!B:B=DATE(2006,5,30), CONCATENATE(Sheet1!D:D," ",
Sheet1!E:E," ", Sheet1!H:H," ", Sheet1!I:I, " ")," ")

works brilliantly, but only as that one function, if I change the
date
to a previous or later one, I don't get a return value.
The formula isn't coming up with an error, but there's obviously
something going on that Excel doesn't like.

Any ideas?


--
moviegrrl

------------------------------------------------------------------------
moviegrrl's Profile:
http://www.excelforum.com/member.php...o&userid=34790
View this thread:
http://www.excelforum.com/showthread...hreadid=545462


--
moviegrrl
------------------------------------------------------------------------
moviegrrl's Profile: http://www.excelforum.com/member.php...o&userid=34790
View this thread: http://www.excelforum.com/showthread...hreadid=545462

--

Dave Peterson

Formula falling over in more than one cell
 

Nope, the dates are definately dates, and don't include time.

What is particularly weird is that it is only the one date (30th May)
that works, any other date doesn't. But they are all entered in the
same fashion and the formula in each cell is identical but for the date
change.
Frustrating isn't the word for it!


Dave Peterson Wrote:
Any chance that some of your dates may be text that looks like a date?

I'd one of the cells that looks like it should work (but doesn't) as a
date.
Then reenter that date.

==
Any chance your dates include time?



moviegrrl wrote:

Absolutely!
For each month I have a set of specific dates - they are all listed
on
the Sheet that I'm trying to work with, they are all in correct date
formula and all I'm doing is copying the formula and changing the
date
but with no luck.

Bob Phillips Wrote:
Are you sure that the other date actually exists within the data?

--
HTH

Bob Phillips

(replace somewhere in email address with googlemail if mailing
direct)

"moviegrrl"

wrote
in message
...

Hi, hope you can help me.
I'm trying to import information from one worksheet into a
calendar
-
if the date value fits, then info from cells on the same line
should
be
imported to the calendar page.

This formula
=IF(Sheet1!B:B=DATE(2006,5,30), CONCATENATE(Sheet1!D:D," ",
Sheet1!E:E," ", Sheet1!H:H," ", Sheet1!I:I, " ")," ")

works brilliantly, but only as that one function, if I change
the
date
to a previous or later one, I don't get a return value.
The formula isn't coming up with an error, but there's obviously
something going on that Excel doesn't like.

Any ideas?


--
moviegrrl


------------------------------------------------------------------------
moviegrrl's Profile:
http://www.excelforum.com/member.php...o&userid=34790
View this thread:
http://www.excelforum.com/showthread...hreadid=545462


--
moviegrrl

------------------------------------------------------------------------
moviegrrl's Profile:
http://www.excelforum.com/member.php...o&userid=34790
View this thread:
http://www.excelforum.com/showthread...hreadid=545462

--

Dave Peterson


--
moviegrrl
------------------------------------------------------------------------
moviegrrl's Profile: http://www.excelforum.com/member.php...o&userid=34790
View this thread: http://www.excelforum.com/showthread...hreadid=545462

Formula falling over in more than one cell
 

Send me your workbook.

--
HTH

Bob Phillips

(replace somewhere in email address with googlemail if mailing direct)

"moviegrrl" wrote
in message ...

Nope, the dates are definately dates, and don't include time.

What is particularly weird is that it is only the one date (30th May)
that works, any other date doesn't. But they are all entered in the
same fashion and the formula in each cell is identical but for the date
change.
Frustrating isn't the word for it!


Dave Peterson Wrote:
Any chance that some of your dates may be text that looks like a date?

I'd one of the cells that looks like it should work (but doesn't) as a
date.
Then reenter that date.

==
Any chance your dates include time?



moviegrrl wrote:

Absolutely!
For each month I have a set of specific dates - they are all listed
on
the Sheet that I'm trying to work with, they are all in correct date
formula and all I'm doing is copying the formula and changing the
date
but with no luck.

Bob Phillips Wrote:
Are you sure that the other date actually exists within the data?

--
HTH

Bob Phillips

(replace somewhere in email address with googlemail if mailing
direct)

"moviegrrl"

wrote
in message
...

Hi, hope you can help me.
I'm trying to import information from one worksheet into a
calendar
-
if the date value fits, then info from cells on the same line
should
be
imported to the calendar page.

This formula
=IF(Sheet1!B:B=DATE(2006,5,30), CONCATENATE(Sheet1!D:D," ",
Sheet1!E:E," ", Sheet1!H:H," ", Sheet1!I:I, " ")," ")

works brilliantly, but only as that one function, if I change
the
date
to a previous or later one, I don't get a return value.
The formula isn't coming up with an error, but there's obviously
something going on that Excel doesn't like.

Any ideas?


--
moviegrrl


------------------------------------------------------------------------
moviegrrl's Profile:
http://www.excelforum.com/member.php...o&userid=34790
View this thread:
http://www.excelforum.com/showthread...hreadid=545462


--
moviegrrl

------------------------------------------------------------------------
moviegrrl's Profile:
http://www.excelforum.com/member.php...o&userid=34790
View this thread:
http://www.excelforum.com/showthread...hreadid=545462

--

Dave Peterson


--
moviegrrl
------------------------------------------------------------------------
moviegrrl's Profile:
http://www.excelforum.com/member.php...o&userid=34790
View this thread: http://www.excelforum.com/showthread...hreadid=545462