Excel formula return values vertically

Asked Jul 21 '20 at 13:35

Active Jul 21 '20 at 13:58

Viewed 111 times

I have a formula set up that is collecting all the values to a corresponding Reference cell. My formula is working great and returning all the values its finds for that particular reference in a single cell (ie 123, 1234, 4422) but I am having trouble trying to figure out how to write it so the value returned are still in a single cell but list vertically instead of horizontally.

this is my code

=TEXTJOIN(", ",TRUE,IF('[ISO Priority Tracking Sheet.xlsx]Piping Input'!$A:$A=A2,'[ISO Priority Tracking Sheet.xlsx]Piping Input'!$C:$C,""))

Any input helps! I hope to keep my formula pretty similar to what is it now; it took awhile to make it work.

edited Jul 21 '20 at 13:58

JvdV

70,606
8
39
70

asked Jul 21 '20 at 13:35

Elliott1197

3

`=TEXTJOIN(", "&Char(10),...` and make sure that the Wrap Text is enabled for that cell – Scott Craner Jul 21 '20 at 13:37
Thank you so much! it worked first try :) Ill mark this as answered once the option pops up I think it takes some time – Elliott1197 Jul 21 '20 at 13:41
Only if @ScottCraner posts an answer. Just out of curiosity, what version of Excel are you running. – JvdV Jul 21 '20 at 13:57
@JvdV excel 2020 – Elliott1197 Jul 22 '20 at 17:29

Excel formula return values vertically

0 Answers0