Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula for Duplicating Rows!! | Excel Discussion (Misc queries) | |||
Match then lookup | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Creating a check mark box | Setting up and Configuration of Excel | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |