Forum Discussion
formula help
I need help on writing a formula to consolidate text horizontally and vertically from one tab to another. almost like a vlookup and sumif for text. I tried to use =textjoin( function but was unsucces...
In B2 on the Summary sheet, as an array formula confirmed with Ctrl+Shift+Enter:
=TEXTJOIN(CHAR(10),TRUE,IF((Detail!$A$1:$A$27=$A2)*(Detail!$C$1:$C$27=B$1),Detail!$B$1:$B$27,""))
Adjust the ranges as needed.
Fill to the right, then down (or vice versa).
Hans that isn't working for me, i've tried. The return i'm getting is everything see attached. HansVogelaar
1) You have to confirm the formula with Ctrl+Shift+Enter to make it an array formula. It won't work as an ordinary formula.
2) There are spaces after some of the animal names on the Detail sheet in your sample workbook. If you remove those the (array) formula should return the correct results.