textjoin

Is it possible to nest TEXTJOIN in a LOOKUP function? I want it to look up what's in B4, look for a match in an array (REF!$B$2:REF!$G$24) and TEXTJOIN what's in REF! columns F and G the same row as what it found in B4. So if the value in B4 is located at REF!B12 in the array, then TEXTJOIN...

Is it possible to add an IF function to TEXTJOIN? I would like to make it so if any number in column 5 in the first VLOOKUP is more than 95 then it gives the message "BP". Can this be done? Here is the formula: =TEXTJOIN("x",,VLOOKUP(A3,FOLDED!$A$2:$I$7,5),VLOOKUP(A3,FOLDED!$A$2:$I$7,6))...

Greetings again! Is there a way to get TEXTJOIN to keep the trailing zeros when having it pull numbers? I have the reference cells set up to carry out to three decimal places. When I use TEXTJOIN to combine data (text and numbers) it's removing the trailing zeros that I need on my numbers...

Hey Everyone, How do I textjoin every 3 columns? data is on one sheet, results on another. example below: Data sheet <tbody> Dog cat Fish Car Truck Plane </tbody> Results sheet <tbody> Dog, Cat, Fish Car, Truck, Plane </tbody> Thanks Andrew

Hi, Is it possible to textjoin and skip cells with the number zero. I understand I can skip blank cells with true/false etc but zero's are not blank. Example below: <tbody> 1 2 0 3 4 1,2,3,4 </tbody> Thanks Andrew

Hi! I have the following situation: In a large table I have conditions in column A and values in column B. I want to create a list of those values in B which meet a given condition in column A ("textjoinif"). To do so I basically have TEXTJOIN(", ";TRUE; IF(columnA="example";columnB;"")). Yet...

Hi I was wondering if there is possible to make a TEXTJOIN formula to only pick up the name one time? Ex; A1=Mark A2=Robert A3=Robert. Then the cell with the TEXTJOIN formula should only have Mark, Robert. I have made this formula but need help with my problem :-) =TEXTJOIN(",",TRUE,O76:O81)