+ Reply to Thread
Results 1 to 6 of 6

Make text join formula dynamic on table columns

  1. #1
    Forum Contributor
    Join Date
    01-16-2014
    Location
    Poland
    MS-Off Ver
    Excel 2016-365
    Posts
    2,940

    Make text join formula dynamic on table columns

    Hi Guys,

    i have 3 columns : ID, ColumnName, TableName

    now i would like to add one additional column and get string like here:

    "Vn_Input_Credentials_Storage_Table_Selection;Vn_Input_Credentials_Storage_Table_Selection;Vn_Input_Credentials_Storage_Table_Selection;Vn_Input_Credentials_Storage_Table_Selection;Vn_Input_Credentials_Storage_Table_Selection;Vn_Input_Credentials_Storage_Table_Selection;Vn_Input_Credentials_Storage_Table_Selection"

    my formula which is doing this perfectly is:
    Please Login or Register  to view this content.
    but problem is that i would like use "ColumnName" as dynamic variable within textjoin,

    something like
    Please Login or Register  to view this content.
    - it is possible without indirect formula ?

    Best,
    Jacek
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    09-30-2019
    Location
    Chiangmai, Thailand
    MS-Off Ver
    Office 2016, Excel 2019
    Posts
    1,234

    Re: Make text join formula dynamic on table columns

    Please try

    =TEXTJOIN(";",TRUE,INDIRECT("Table1["&B2&"]"))

    Regards.

  3. #3
    Forum Contributor
    Join Date
    01-16-2014
    Location
    Poland
    MS-Off Ver
    Excel 2016-365
    Posts
    2,940

    Re: Make text join formula dynamic on table columns

    Thanks,

    so no way to do this without indirect?

    Best,
    Jacek

  4. #4
    Forum Expert
    Join Date
    09-30-2019
    Location
    Chiangmai, Thailand
    MS-Off Ver
    Office 2016, Excel 2019
    Posts
    1,234

    Re: Make text join formula dynamic on table columns

    I don't know. Sorry.


    Regards.

  5. #5
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    7,211

    Re: Make text join formula dynamic on table columns

    Please try

    =TEXTJOIN(";";;INDEX(Table1;;MATCH(B2;Table1[#Headers];)))
    Attached Files Attached Files

  6. #6
    Forum Contributor
    Join Date
    01-16-2014
    Location
    Poland
    MS-Off Ver
    Excel 2016-365
    Posts
    2,940

    Re: Make text join formula dynamic on table columns

    thanl you Bo_Ry!

    Jacek

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Join table into text with headers and bullet points.
    By JasonNeedsHelp in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-13-2021, 03:35 AM
  2. Make new dynamic table with specific columns from previous one
    By rodmorais in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-07-2019, 04:11 PM
  3. PowerQuery: Expand all columns after table join
    By Barslund in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-25-2018, 04:59 AM
  4. Need Formula to Join to Columns and Duplicate
    By mhedge in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-17-2015, 07:53 PM
  5. Make conditionally sized dynamic table (data table)
    By myersac in forum Excel General
    Replies: 0
    Last Post: 09-17-2014, 03:23 PM
  6. Join 2 Cell to make a new formula
    By racer25 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-21-2008, 09:14 AM
  7. Replies: 4
    Last Post: 02-21-2006, 05:00 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1