SOLVED

Vlookup & Textjoin

Occasional Contributor

Is it possible to use text join along with vlookup function to get values from different columns in to one cell? If so how can this be done. If it is not possible with these two functions is there any other method to do this.

3 Replies

@Rudrabhadra 

Could you explain in more detail what you want.

And could you attach a sample workbook (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar? Thanks in advance.

best response confirmed by Rudrabhadra (Occasional Contributor)
Solution

@Rudrabhadra 

=TEXTJOIN(",",,VLOOKUP(C10,F5:I8,{2,3,4},FALSE))

You can try this formula.

textjoin vlookup.JPG 

I had used char(10) in the delimiter for separating the lines in to one cell. Now as per the given formulae it takes all columns to separate lines in the cell. I am looking for a possible way to separate only specific columns as required, not all columns to separate lines?
Formula used:
=TEXTJOIN(CHAR(10),,VLOOKUP(Sheet1!A2,Master!A:N,{3,4,5,6,7,8,9,10,11,12,13,14},0))
here I need column 4 and 5 to appear in the same line (no need to separate it in different lines).
Thanks in advance....