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?