Issues with formula not duplicating

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Why have you reposted the same question when Bob is responding to the
previous? It's not very fair.

Andy.
 
Actually it wasn't deliberate - this second posting was through th
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 stil
looking for an answer...

Wasn't meaning to tread on anyone's toes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula falling over in more than one cell 5
Formulas and counting 8
SUMPRODUCT with two valid criteria 1
Please help me simplify the given code 9
Max with Multiple Ifs 3
Copy Data from One Spreadsheet to Another ?????? 5
The cell currently being evaluated contains - TIA 4
Complex date VBA - insert a certain weekday 5

Back
Top