+ Reply to Thread
Results 1 to 8 of 8

Extracting text from table and inserting it in another table/graph

  1. #1
    Registered User
    Join Date
    04-23-2018
    Location
    Norway
    MS-Off Ver
    2016
    Posts
    6

    Post Extracting text from table and inserting it in another table/graph

    Hi!
    I'm having trouble transfering or extracting text from a cell into a table.

    Are there any functions that could do this?

    To give an example of what I am looking for:

    In column H there is comments from different people. I want Excel to match name, date and comment and transfer it to a comment section in a table.

    So when i for example choose 16. april and choose a name in a dropdown list, i get the comments from that day from that person.

    Is this possible?

    Thanks!

    Best regards, Thuns

  2. #2
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,062

    Re: Extracting text from table and inserting it in another table/graph

    Post a sample spreadsheet with expected results, remove any sensitive data, create a mockup example if necessary.
    Use the Go Advanced option at the bottom of the page then scroll down to Manage Attachments as the "paperclip" method does not work on this forum.
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

  3. #3
    Registered User
    Join Date
    04-23-2018
    Location
    Norway
    MS-Off Ver
    2016
    Posts
    6

    Re: Extracting text from table and inserting it in another table/graph

    I have now made an example of what i want to happen. I used Sumifs to get the other numbers in the table to auto update when i change date or person, but that does not work with text.

    Hope this clarifies my problem
    Attached Files Attached Files

  4. #4
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,900

    Re: Extracting text from table and inserting it in another table/graph

    Much clearer!!

    In O7, copied down:

    =INDEX(TablData[Comments],MATCH(1,INDEX((TablData[Date]=J7)*(TablData[Name]=$K$4),),0))

    you will need ; as separators and not , as shown in the above formula.
    Attached Files Attached Files
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

  5. #5
    Registered User
    Join Date
    04-23-2018
    Location
    Norway
    MS-Off Ver
    2016
    Posts
    6
    Quote Originally Posted by Glenn Kennedy View Post
    Much clearer!!

    In O7, copied down:

    =INDEX(TablData[Comments],MATCH(1,INDEX((TablData[Date]=J7)*(TablData[Name]=$K$4),),0))

    you will need ; as separators and not , as shown in the above formula.

    Wow! What a hero you are! The answer came so quick!

    Thank you so much!
    Have a great week!

    Best regards, Thuns.

  6. #6
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,900

    Re: Extracting text from table and inserting it in another table/graph

    You're welcome.



    If that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.

    It'd also be appreciated if you were to click the Add Reputation button at the foot of any of the posts of all members who helped you reach a solution.

  7. #7
    Registered User
    Join Date
    04-23-2018
    Location
    Norway
    MS-Off Ver
    2016
    Posts
    6

    Re: Extracting text from table and inserting it in another table/graph

    Hi again!
    Sorry for bothering you guys, but when i try to use the formula (=INDEX(TablData[Comments],MATCH(1,INDEX((TablData[Date]=J7)*(TablData[Name]=$K$4),),0)) ) in my main workbook, i get #I/T. I have tried different solutions, but i can't find the reason.

    First question: This error message (#I/T) is due to the MATCH formula?
    Second question: The number 1 in the MATCH formula, what kind of function does it have?

    I have changed this formula to match my main woorkbook, but can't get it right.

    It worked perfectly in my mockup..

    Regards, Thuns.

  8. #8
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,900

    Re: Extracting text from table and inserting it in another table/graph

    If you're in Norway (and are using Norwegian settings), you will need to use ; instead of , in the formula (as mentioned in Post 4). The 1 in match means "TRUE", i.e. return the INDEX value when the MATCH critieria are TRUE.

+ 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. Replies: 3
    Last Post: 07-12-2017, 04:44 AM
  2. Extracting data from table by cell or text color
    By johnwick22 in forum Excel General
    Replies: 2
    Last Post: 06-03-2017, 04:34 PM
  3. Comparing cell value to a table then extracting data from second table column
    By JaredMcOffice in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-05-2017, 01:42 AM
  4. Replies: 5
    Last Post: 01-28-2016, 01:43 PM
  5. [SOLVED] Inserting subscripted text in word table using VBA
    By Craptus in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-24-2013, 11:33 AM
  6. Extracting data from a table based on a common entries with another table
    By shannoncox in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-31-2012, 04:45 PM
  7. Replies: 2
    Last Post: 02-10-2011, 10:08 AM

Tags for this Thread

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