Google Sheet formula

[hieptrinh96]

so I have an appsheet app that uses several google sheet tabs. I am having some issues using that data inside the sheets. 
Specifically with this formula 
=ARRAYFORMULA( IF(D2:D<>"", IFERROR( VLOOKUP( split(D2:D, ","), QUERY(AllUsers!C:E, "SELECT E,C", 0), 2, FALSE ), "" ), "" ) )

I got the correct output but since I used split(), the output is placed in cells adjacent with each other instead of just being in the same cell. 
I tried using transpose and textjoin before the vlookup and textjoin(whole formula) but when there is new data, the output is being placed in the same cell regardless of which row that new data is coming from. 

[1minManager]

This is not really an Appsheet question.  So consider asking it on the Google Sheets forums.  But as a quick suggestion, try the formula actually in the cell and without ARRAYFORMULA().  As I've found this can change the result as not everything works inside ARRAYFORMULA()

Simon, 1minManager.com