Issues with formula not duplicating
 

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. There are a number of
dates within the spreadsheet, so it isn't like there's a lack of data.
The formula isn't coming up with an error, but there's obviously something
going on that Excel doesn't like.

Any ideas?

Issues with formula not duplicating
 

Why have you reposted the same question when Bob is responding to the
previous? It's not very fair.

Andy.

"SasR" 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. There are a number of
dates within the spreadsheet, so it isn't like there's a lack of data.
The formula isn't coming up with an error, but there's obviously something
going on that Excel doesn't like.

Any ideas?

Issues with formula not duplicating
 

Actually it wasn't deliberate - this second posting was through the
Microsoft Forum, and I didn't realise that it would be reposted here.
The reason I posted it at the Microsoft forum is that I am still
looking for an answer...

Wasn't meaning to tread on anyone's toes

Why have you reposted the same question when Bob is responding to the
previous? It's not very fair.

Andy.

"SasR" 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. There are a number
of
dates within the spreadsheet, so it isn't like there's a lack of
data.
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=545509