+ Reply to Thread
Results 1 to 5 of 5

Lookup formula to find part of a text string

  1. #1
    Forum Contributor
    Join Date
    11-03-2012
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    246

    Lookup formula to find part of a text string

    Hi

    I use the following formula "=IFERROR(LOOKUP(2,1/($E$3:$E$92=K9),$I$3:$I$92),"") " to lookup specific text to find a value £.
    K9 contains my specific text to search for

    I need to modify the search to find the specific text which in some cases will now appear in a string of text.

    Normally the entries in the list of items would appear like 'BT Group

    Now I have entries that appears as '0334 24SEP15 , BANWY FUELS LTD , WELSHPOOL GB

    The text to search for will be 'BANWY FUELS LTD

    The numbers preceding BANWY FUELS LTD will continually change for each entry.

    Many thanks in advance, your help will be greatly appreciated. Thank you.

  2. #2
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,576

    Re: Lookup formula to find part of a text string

    it's not clear from your question what you trying to do but try

    Formula: copy to clipboard
    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    08-02-2015
    Location
    Hyderabad
    MS-Off Ver
    2007
    Posts
    160

    Re: Lookup formula to find part of a text string

    Please share the excel report so that it will make easy to resolve this.

  4. #4
    Forum Contributor
    Join Date
    11-03-2012
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    246

    Re: Lookup formula to find part of a text string

    Please see attached file
    Attached Files Attached Files

  5. #5
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,904

    Re: Lookup formula to find part of a text string

    l4=IFERROR(LOOKUP(2,1/SEARCH(SUBSTITUTE(K4,"""",""),E$3:E$92),F$3:F$92*-1),"")
    Please Login or Register  to view this content.
    Try this and copy towards down
    Samba

    Say thanks to those who have helped you by clicking Add Reputation star.

+ 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: 2
    Last Post: 03-18-2015, 07:30 PM
  2. [SOLVED] Lookup formula to find code from part of text
    By mlun in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-06-2013, 08:35 AM
  3. Lookup for Code that Corresponds to Part of string of text in a Cell
    By brandnew22 in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 08-06-2013, 07:33 PM
  4. Vlookup to find part of text string
    By boatbabe in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-06-2013, 10:32 AM
  5. [SOLVED] Formula to find the part of string.
    By hecgroups in forum Excel Programming / VBA / Macros
    Replies: 20
    Last Post: 05-20-2012, 10:38 AM
  6. Find/use part of a text string
    By -emma- in forum Excel General
    Replies: 2
    Last Post: 12-06-2008, 07:14 PM
  7. [SOLVED] Find and replace part of a text string
    By [email protected] in forum Excel General
    Replies: 2
    Last Post: 07-10-2006, 05:39 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