Forum Discussion
Solved
TEXTJOIN/Nested IF error
Ok, So I’m almost complete with this simple excel database I created to help make my job more efficient. The only issue I am running into is creating an accurate TEXTJOIN function. The conditions and...
I guess you are on an old version of Excel. Since this is an array formula you have to use the magic keystroke CRTL-SHIFT-ENTER.
Hi, thanks for your response the string you provided is one that I initially used and excel returned #VALUE!
The one I currently have keyed is this:
=TEXTJOIN(" , ",TRUE,IF('124'!K6="H",'124'!I6,IF('124'!N6="H",'124'!L6,IF('124'!Q6="H",'124'!O6,""))))
Although it is returning the value from cell I6 it is not including the other "H" value from N6, this is the main issue I am encountering, its only giving me a partial return.
The one I currently have keyed is this:
=TEXTJOIN(" , ",TRUE,IF('124'!K6="H",'124'!I6,IF('124'!N6="H",'124'!L6,IF('124'!Q6="H",'124'!O6,""))))
Although it is returning the value from cell I6 it is not including the other "H" value from N6, this is the main issue I am encountering, its only giving me a partial return.
I guess you are on an old version of Excel. Since this is an array formula you have to use the magic keystroke CRTL-SHIFT-ENTER.
- Thank You,
Not how I expected but the CRTL-SHIFT-ETR function did work. Apparently something I hadn't know is Excel will not allow you to enter an array formula over merged cells. This is certainly helpful for the time being though, Thank you!