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