Forum Discussion

Brass Contributor

Jul 08, 2022

Solved

Vlookup & Textjoin

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 an...

developer

excel

Formulas and Functions

office 365

Office Scripts

OliverScheurich
Jul 08, 2022
Rudrabhadra
=TEXTJOIN(",",,VLOOKUP(C10,F5:I8,{2,3,4},FALSE))
You can try this formula.

OliverScheurich

Gold Contributor

Jul 08, 2022

Rudrabhadra

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

You can try this formula.

Rudrabhadra
Brass Contributor
Jul 09, 2022
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....