+ Reply to Thread
Results 1 to 10 of 10

Drop down pulls string value (paragraph) and is concatenated.

  1. 01-05-2014, 10:16 PM #1
    AM949
    AM949 is offline
    Registered User
    Join Date
    01-05-2014
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    6

    Drop down pulls string value (paragraph) and is concatenated.

    New user with basic knowledge faced with a multi-part challenge.

    I have a list of 10 items (multiple words) in a drop down

    Based on what is selected in the drop-down, I am trying to figure out the best way for it to pull the corresponding text paragraph. This would then be concatenated with a numerical value inputed b the user in another cell. The final output would be displayed in a final cell.

    I have figured out how to concatenate between one cell and the other cell with the paragraph but I am at a loss for how to make it more dynamic in the sense that the drop down selection drives the paragraph being selected and then taking the value in cell A1 to concatenate within that paragraph and outputting the final text to be copied out from excel.

    I tried looking at posts for dependent data verification and I felt like I was on the right track but hit a wall.

    Any and all help is greatly appreciated!

    Excel 2003
    Reply With QuoteRegister To Reply
  2. 01-05-2014, 10:39 PM #2
    alvin-chung
    alvin-chung is offline
    Valued Forum Contributor
    Join Date
    12-25-2013
    Location
    Singapore
    MS-Off Ver
    Excel 2016
    Posts
    506

    Re: Drop down pulls string value (paragraph) and is concatenated.

    Hi, try upload a sample file with expected result?
    Reply With QuoteRegister To Reply
  3. 01-05-2014, 11:24 PM #3
    AM949
    AM949 is offline
    Registered User
    Join Date
    01-05-2014
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    6

    Re: Drop down pulls string value (paragraph) and is concatenated.

    Thanks for responding! I will upload the working doc tomorrow morning, hopefully that will help!
    Reply With QuoteRegister To Reply
  4. 01-06-2014, 03:46 PM #4
    AM949
    AM949 is offline
    Registered User
    Join Date
    01-05-2014
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    6

    Re: Drop down pulls string value (paragraph) and is concatenated.

    Here is a sample fileSample.xls
    Reply With QuoteRegister To Reply
  5. 01-06-2014, 04:26 PM #5
    ChemistB
    ChemistB is offline
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,582

    Re: Drop down pulls string value (paragraph) and is concatenated.

    Okay, not sure of the flow here. User inputs a 2. does that influence the dropdown choices? or whether Text 1 or Text 2 is chosen? If the second, then is the maximum value the user can enter a 2?

    On using lists on other pages. Use a defined name and then you can use that name in your data validation. for example, I named Data!B2:B11 = DataList
    and then in data validation, used = DataList
    ChemistB
    My 2?

    substitute commas with semi-colons if your region settings requires
    Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
    If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
    Reply With QuoteRegister To Reply
  6. 01-06-2014, 04:40 PM #6
    AM949
    AM949 is offline
    Registered User
    Join Date
    01-05-2014
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    6

    Re: Drop down pulls string value (paragraph) and is concatenated.

    Sample2.xls
    User input box does not impact drop down choice.
    User input is a numerical variable that is only used to concatenate into the final text output.

    I am not familiar if excel can concatenate at a specific location within a text string (such as a paragraph) so i split the two text items into two options so I could just insert the concatenation in the middle. I uploaded a new sample to show this.
    Reply With QuoteRegister To Reply
  7. 01-06-2014, 04:49 PM #7
    ChemistB
    ChemistB is offline
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,582

    Re: Drop down pulls string value (paragraph) and is concatenated.

    Okay, take a look at the attached. I named the list DataList as I mentioned earlier. I then moved all your choices over to the DataTab into a table which I named DataTable. Then I used VLOOKUP to pull back the proper results
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  8. 01-06-2014, 05:00 PM #8
    ChemistB
    ChemistB is offline
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,582

    Re: Drop down pulls string value (paragraph) and is concatenated.

    Here, I placed a "^" in the single string where you wanted the number inserted (see data!C15:C24) and then used this formula (Main!A35)

    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  9. 01-06-2014, 06:39 PM #9
    AM949
    AM949 is offline
    Registered User
    Join Date
    01-05-2014
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    6

    Re: Drop down pulls string value (paragraph) and is concatenated.

    ChemistB,

    Thank you so much for your help! You have really inspired me to dig in more and learn more about Excel. Thank you again!!
    Reply With QuoteRegister To Reply
  10. 01-06-2014, 11:02 PM #10
    vlady
    vlady is offline
    Forum Moderator vlady's Avatar
    Join Date
    09-22-2011
    Location
    Philippines - OLSHCO -Guimba-Nueva Ecija
    MS-Off Ver
    2021
    Posts
    4,361

    Re: Drop down pulls string value (paragraph) and is concatenated.

    FORUM MODERATOR'S REQUEST:

    Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as "SOLVED".
    For the meantime I'll do it for you.

    How?
    New quick method:
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

    Or you can use this way:

    How to mark a thread Solved
    Go to the first post
    Click edit
    Click Go Advanced
    Just below the word Title you will see a dropdown with the word No prefix.
    Change to Solved
    Click Save

    Note:
    You can also thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given.
    By doing so you can add to the reputation(s) of those who helped and shared their time in helping you.
    I think people forget the word "THANK YOU!!!!" Do you still know it???

    There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "

    Regards,
    Vladimir
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Searching for multiple instances of a string within a paragraph of text
    By Muzroy in forum Excel General
    Replies: 9
    Last Post: 10-29-2013, 05:19 AM
  2. [SOLVED] How to retrieve particular text string from complex paragraph by Macro ?
    By nur2544 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-05-2013, 09:55 PM
  3. Drop down that looks to one sheet and pulls info into a word document
    By tokool in forum Excel General
    Replies: 0
    Last Post: 03-18-2012, 11:53 AM
  4. How To Parse Text String at Carriage Return Line Feed (paragraph)
    By longfisher in forum Excel General
    Replies: 8
    Last Post: 11-07-2008, 09:26 AM
  5. [SOLVED] how to Detect paragraph in cell in string?
    By dm16s in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-22-2005, 05:05 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1