+ Reply to Thread
Results 1 to 2 of 2

excel formula to search Multiple strings in several columns and return strings in a separa

  1. #1
    Registered User
    Join Date
    08-13-2013
    Location
    Suwon
    MS-Off Ver
    Excel 2010
    Posts
    5

    excel formula to search Multiple strings in several columns and return strings in a separa

    I want a Excel Formula for Search multiple String from Multiple Columns and return Values If Found in different columns. For Example I have Data Like:

    In Column A : 3 data: A2: URR/THU/MON ,A3: URR/ETC.C ,A4: URL/ETC.V...........

    In Column B : 1 data: B2: URL/THR/RTH ......

    Lets assume This Much Data I Have. and I wanted to search URL and URR from column A and B. and Need to return Values in Column C. If 2 value found need to return both with sepearte Coma. I cant Use Nested IF because in that only 7 "IF" I can Use. I have totally more than 25 Keywords to search in more than 20 columns.

  2. #2
    Valued Forum Contributor
    Join Date
    09-15-2011
    Location
    Chennai, India
    MS-Off Ver
    Excel 2010
    Posts
    436

    Re: excel formula to search Multiple strings in several columns and return strings in a se

    Please check if im right.
    Attached Files Attached Files
    Please click 'Add reputation', if my answer helped you.

+ 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. Truncate text strings using LEFT and FIND/SEARCH for multiple search terms
    By ngdoherty in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-17-2013, 07:51 PM
  2. Formula to search for multiple strings
    By newnoise in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-24-2012, 08:50 PM
  3. Replies: 5
    Last Post: 03-29-2012, 04:12 AM
  4. Replies: 3
    Last Post: 05-28-2011, 01:43 PM
  5. -how to use VBA to search strings and return values or cells nearby
    By dp256 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 05-20-2009, 04:24 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1