+ Reply to Thread
Results 1 to 8 of 8

Finding text

  1. 06-05-2023, 03:29 PM #1
    Fjeld
    Fjeld is offline
    Registered User
    Join Date
    06-05-2023
    Location
    Denmark
    MS-Off Ver
    Microsoft 365
    Posts
    4

    Question Finding text

    Hi all,

    I have tried and tried finding a solution, and maybe there are none. But here goes:

    My problem is, that I in one sheet have a lot of data, and in another a lookup sheet. The lookup sheet includes the lookup value that is a short text. In the data sheet there is a column with a big text, and in this text the lookup values are. I now need to find the row in the lookup sheet. How can I do this? If it was the other way around it would be easy.

    Fx. the text can be found in Column A in the data sheet, but in each cell the starting point of the short text differentiates.

    Do anyone have the solution?

    Best regards,
    Fjeld
    Reply With QuoteRegister To Reply
  2. 06-05-2023, 03:41 PM #2
    TMS
    TMS is offline
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,457

    Re: Finding text

    Welcome to the forum.

    You could probably use INDEX/MATCH rather than VLOOKUP. Or, with 365, you can use FILTER.



    Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file and a mocked up solution.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke

    Reply With QuoteRegister To Reply
  3. 06-05-2023, 04:00 PM #3
    Fjeld
    Fjeld is offline
    Registered User
    Join Date
    06-05-2023
    Location
    Denmark
    MS-Off Ver
    Microsoft 365
    Posts
    4

    Re: Finding text

    Here is also an example file:
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  4. 06-05-2023, 04:14 PM #4
    AliGW
    AliGW is online now
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,903

    Re: Finding text

    Administrative Note:

    Welcome to the forum.

    We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not told us about this. You are required to do so.

    Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important: https://excelguru.ca/a-message-to-forum-cross-posters/

    (Note: this requirement is not optional. As you are new here, I shall do it for you this time: https://www.mrexcel.com/board/thread...-text.1238595/)
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
  5. 06-05-2023, 04:18 PM #5
    Fjeld
    Fjeld is offline
    Registered User
    Join Date
    06-05-2023
    Location
    Denmark
    MS-Off Ver
    Microsoft 365
    Posts
    4

    Re: Finding text

    Hi AliGW, sorry about that. I wasn't aware of this rule. Will make sure to either not to cross-forum post again, or to make sure to create a link.
    Reply With QuoteRegister To Reply
  6. 06-06-2023, 02:04 AM #6
    AliGW
    AliGW is online now
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,903

    Re: Finding text

    Can you manually add expected results to the sample workbook, please?

    Maybe this is what you want:

    =LOOKUP(99999,SEARCH('Lookup sheet'!$A$2:$A$6,B2),'Lookup sheet'!$B$2:$B$6)

    There is no match in the second row.
    Attached Files Attached Files
    Last edited by AliGW; 06-06-2023 at 02:08 AM. Reason: Workbook added.
    Reply With QuoteRegister To Reply
  7. 06-12-2023, 10:35 AM #7
    Fjeld
    Fjeld is offline
    Registered User
    Join Date
    06-05-2023
    Location
    Denmark
    MS-Off Ver
    Microsoft 365
    Posts
    4

    Re: Finding text

    Hi AliGW,

    Thanks a lot. This works perfect. I have tried it on the full dataset and it works like intended.

    Do I need to close the thread?
    Reply With QuoteRegister To Reply
  8. 06-12-2023, 11:02 AM #8
    AliGW
    AliGW is online now
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,903

    Re: Finding text

    Glad to have helped.

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

    Also, if you have not already done so, you may not be aware that you can thank anyone who offered you help towards a solution for your issue by clicking the small star icon (* Add Reputation) 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 all those who offered help.
    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. [SOLVED] Request help finding text next to a date, finding the same date in another column...
    By Biff Malibu 636 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-11-2016, 12:34 AM
  2. I need to give a cell a value based on finding specific text within a string of text
    By Ruski1106 in forum Excel Formulas & Functions
    Replies: 24
    Last Post: 11-10-2015, 07:27 PM
  3. [SOLVED] Finding a tag or text within text as part of SUMIFS formula
    By twaccess in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-17-2015, 08:54 AM
  4. [SOLVED] Need to search cell for text string and paste text in based on finding
    By roland77 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-29-2014, 08:56 PM
  5. finding a specific text and average the number of data of that text
    By bravo8939 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-09-2013, 10:16 PM
  6. Finding variable length text strings within a larger text string
    By Bonnister in forum Excel General
    Replies: 6
    Last Post: 03-08-2012, 10:35 AM
  7. Finding a text in a list against a specific item and returning the text in new sheet
    By marktaylor in forum Excel General
    Replies: 6
    Last Post: 07-15-2009, 07:44 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1