+ Reply to Thread
Results 1 to 4 of 4

Search column and if results found put an X if not leave blank

  1. #1
    Registered User
    Join Date
    11-02-2011
    Location
    California
    MS-Off Ver
    Excel 2003
    Posts
    2

    Search column and if results found put an X if not leave blank

    I found this:
    link
    and it seems to be nearly what I need, but does not work.

    I'm looking for a way to have a cell search a column for text, exact text, such as "ITEM", "FORM", "TREE", etc. and if it's found in the column then the cell in question simply displays an X. If not leave the cell blank.

    Here's what I'm doing:
    Column A is a list of ~300 key words.
    Column B, C, D etc are templates (Ford, Chevy, Dodge, etc) that needs to have an X next to those items that they have for a side by side comparison purpose.
    I can pull a list of items (in text only) each template has, so I want to be able to paste these items into a column further to the right. So for this example I'll put Ford's list of items into E, Chevy into F, Dodge into G.

    I think this was almost there:
    =IF(E:E= A3, "X", "")

    TIA
    Last edited by slo5oh; 11-04-2011 at 07:35 PM.

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,164

    Re: Search column and if results found put an X if not leave blank

    Hi slo5oh and welcome to the forum,

    I'm not sure I completely undersand the question but look at the attached to see if it works for you.
    Attached Files Attached Files
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  3. #3
    Registered User
    Join Date
    11-02-2011
    Location
    California
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Search column and if results found put an X if not leave blank

    MarvinP,

    THANK YOU!!! That's exactly what I was trying to do! You just saved me probably 12 hours worth of work.

    I don't suppose you can explain to me how that worked?
    =IF(ISERROR(MATCH($A7,J$2:J$4,0)),"","X")

  4. #4
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,164

    Re: Search column and if results found put an X if not leave blank

    Yep,

    Match returns a number of the row that matches. I used the word in Column A to match any of the range in DodgeWords (if I use your formula above). If the match doesn't come back with a number it will give some error. I used the function of IsError and if it works then display a blank. If it gets a hit then put in an X.

    If you look at Formula Evaluate Tool you can step through what each cell does.
    See an example at http://excel.tips.net/T002999_Evaluating_Formulas.html

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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