+ Reply to Thread
Results 1 to 4 of 4

Pulling certain criteria from a string of text and match to a pallet number

  1. #1
    Forum Contributor
    Join Date
    04-06-2017
    Location
    Wolverhampton
    MS-Off Ver
    Office 365
    Posts
    471

    Pulling certain criteria from a string of text and match to a pallet number

    Hello

    I need a formula to pull certain text from a string,

    IN Col AA there a formula that's working of sorts, however, I need the formula to be dynamic enough to recognize each of the below text
    COV
    RHL
    LHL
    N/L
    A205

    It also needs to look at the pallet number in COL X,

    please see attached to help to understand..

    thanks for looking
    Attached Files Attached Files

  2. #2
    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: Pulling certain criteria from a string of text and match to a pallet number

    I suspect there's more to this.... where does CAPS and so on come into this??

    =IFERROR(LOOKUP(10^10,SEARCH({"COV","RHL","LHL","N/L","A205"},INDEX(B:B,MATCH(X4,D:D,0))),{"COV","RHL","LHL","N/L","A205"}),"")
    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

  3. #3
    Forum Contributor
    Join Date
    04-06-2017
    Location
    Wolverhampton
    MS-Off Ver
    Office 365
    Posts
    471

    Re: Pulling certain criteria from a string of text and match to a pallet number

    Cheers Glenn, as per, brilliant

  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: Pulling certain criteria from a string of text and match to a pallet number

    Oh!! That was lucky... or skillful. Let's call it skillful!!

    You're welcome.



    It would be very nice if you were to just click the Add Reputation button at the foot of any of the posts of members who helped you reach a solution.

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

+ 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: 4
    Last Post: 04-21-2020, 07:32 AM
  2. Return a text and number string based on multiple criteria
    By McKneezy in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-12-2019, 10:25 AM
  3. [SOLVED] Pulling Number from Text String
    By sbeatty in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-03-2017, 12:51 PM
  4. Replies: 2
    Last Post: 05-27-2016, 12:30 AM
  5. Match all text and closest number in alphanumeric string
    By geebers97 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-21-2014, 11:32 AM
  6. Index Match nesting w/ partial text string criteria
    By dohearn in forum Excel General
    Replies: 1
    Last Post: 10-25-2011, 03:42 PM
  7. Pulling only the number out of a string
    By bconner in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-19-2008, 03:32 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