Forum Discussion
IF formula not listing all the information from target cell. Is there a limit on data in cells?
I have a TEXTJOIN IF formula that works but in the target location i get a #VALUE. I went looking on why and couldn't find a reason. I noticed that the cell it was grabbing would work if there was ma...
Those were examples. in the picture i show what I'm talking about. if the cell has too many characters inside it for some reason it wont return properly unless i single out the cell.
I missed that, I just updated my answer,
once you write the formula just press Ctrl+Shift+Enter at the same time
once you write the formula just press Ctrl+Shift+Enter at the same time
- Ok so that didn't work either. I did find out that you can't do a Ctrl+Shift+Enter in merged cells though. It just gave me the same #VALUE!.
- when you are dealing with array, it depends on the formula like the on on the photo, it is a matter of the targeted cell should be the same number as the source. So in this case it will give you error since the target cell merged cell which means just 1 cell.
- Well the top part in the photo "output" section is merged cells and it worked with the array just fine. it the bottom part doesn't work properly. there is not difference in the formula other than the cell ranges. the thing that stops it all is the data in the first cell in the second row of the "table". I do appreciate you help on this by the way. It has been frustrating me for the past few days trying to figure this out.