textjoin issues

Hello Everyone ,    I have the text join formula to combine a series of text in a row.  But the cells have a vlookup formula to get data from another sheet. When try to join the text resulted in t...