+ Reply to Thread
Results 1 to 2 of 2

How to search cell contents in two columns, for strings in a range of unique data

  1. #1
    Registered User
    Join Date
    05-08-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2007 and Excel 2010
    Posts
    7

    Post How to search cell contents in two columns, for strings in a range of unique data

    Hi all!

    I was fortunate enough to find 50% of my problem resolved by a great solution, provided by forum guru, martindwilson, on a thread entitled "Searching if a cell contains a range of values" - Found here: http://www.excelforum.com/excel-form...ml#post3756333

    I'm hoping that someone can shed some light on how I can solve the other half of my problem. In a nutshell:

    I have a range of valid, unique data in an array called Affected_Systems, which can appear anywhere within a cell in either column H or column I. I need to identify in column CA, whether the unique data appears in either of the two columns (H or I); and flag it "Yes" or "No", as appropriate.

    The formula that martindwilson provided in the other thread is:


    =IF(ISNUMBER(LOOKUP(10^99,SEARCH(gtld,A2))),"found","not found")

    I appreciate any input.

    PS - Thanks, in advance, to martindwilson for the above formula... which will certainly prove useful for future endeavours.

    Cheers!

  2. #2
    Registered User
    Join Date
    05-08-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2007 and Excel 2010
    Posts
    7

    Re: How to search cell contents in two columns, for strings in a range of unique data

    I've solved my problem!

    It turns out that the OR statement that I tried to infuse was incorrectly applied. The following version worked perfectly:

    =IF(OR(ISNUMBER(LOOKUP(10^99,SEARCH(Affected_Systems,H21)))=TRUE, ISNUMBER(LOOKUP(10^99,SEARCH(Affected_Systems,I21)))=TRUE),"Yes","No")

+ 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. excel formula to search Multiple strings in several columns and return strings
    By krratna123 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-13-2013, 11:20 AM
  2. Replies: 1
    Last Post: 08-13-2013, 08:32 AM
  3. [SOLVED] search text of cell in a range and return the contents in the corresponding column
    By kumail in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-18-2013, 06:42 PM
  4. Search Text of Cell in a range and return the contents
    By knowing in forum Excel General
    Replies: 8
    Last Post: 11-19-2012, 08:57 AM
  5. Search Text of Cell in a range and return the contents
    By shanipk82 in forum Excel General
    Replies: 3
    Last Post: 11-26-2010, 01:34 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