+ Reply to Thread
Results 1 to 4 of 4

String search and value return

  1. 02-02-2022, 02:43 PM #1
    ara.darakjian
    ara.darakjian is offline
    Registered User
    Join Date
    02-24-2013
    Location
    USA
    MS-Off Ver
    16.63.1 (2022)
    Posts
    82

    String search and value return

    I have a 2 worksheet workbook where I have to search for a string from one worksheet within the string in the cells of the other worksheet and return the complete string upon a successful search.

    Search Criteria - [Import File AJD] Column A, Row X
    Search Array - [res.partner] Column A, Row 2...77
    Search Result - [res.partner] Column A, Row [match]
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 02-02-2022, 03:13 PM #2
    sourabhg98
    sourabhg98 is offline
    Forum Expert sourabhg98's Avatar
    Join Date
    10-22-2014
    Location
    New Delhi, India
    MS-Off Ver
    Excel 2007, 2013
    Posts
    1,899

    Re: String search and value return

    Enter the following formula in cell B2 and copy down -

    Please Login or Register  to view this content.
    Last edited by sourabhg98; 02-02-2022 at 03:43 PM.
    Happy to Help

    How to upload excel workbooks at this forum - http://www.excelforum.com/the-water-...his-forum.html

    "I don't get things easily, so please be precise and elaborate"

    If someone's post has helped you, thank by clicking on "Add Reputation" below the post.
    If your query is resolved please mark the thread as "Solved" from the "Thread Tools" above.

    Sourabh
    Reply With QuoteRegister To Reply
  3. 02-03-2022, 08:54 AM #3
    ara.darakjian
    ara.darakjian is offline
    Registered User
    Join Date
    02-24-2013
    Location
    USA
    MS-Off Ver
    16.63.1 (2022)
    Posts
    82

    Re: String search and value return

    Thank you!!!
    Reply With QuoteRegister To Reply
  4. 02-03-2022, 09:01 AM #4
    sourabhg98
    sourabhg98 is offline
    Forum Expert sourabhg98's Avatar
    Join Date
    10-22-2014
    Location
    New Delhi, India
    MS-Off Ver
    Excel 2007, 2013
    Posts
    1,899

    Re: String search and value return

    Glad I could assist If your query is resolved please mark the thread as "Solved" from the "Thread Tools" above. If someone's post has helped you, you can thank by clicking on "Add Reputation" below the post.
    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. Search for string in a 2d array and return string
    By david0985 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-11-2016, 04:59 AM
  2. Script to Search for a specific String then return cell values above that String-4
    By owensjb2 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-03-2015, 01:28 AM
  3. [SOLVED] Script to Search for a specific String then return cell values above that String-3
    By owensjb2 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-01-2015, 01:50 PM
  4. [SOLVED] Script to Search for a specific String then return cell values above that String-2
    By owensjb2 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-01-2015, 01:00 PM
  5. [SOLVED] Script to Search for a specific String then return cell values above that String
    By owensjb2 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-01-2015, 11:28 AM
  6. Search column for string and return every row with that string in new sheet
    By myers601 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-03-2012, 06:02 PM
  7. search for key in string of text & return position in that string
    By cashflowpro in forum Excel General
    Replies: 2
    Last Post: 02-26-2008, 03:22 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