Results 1 to 8 of 8

Thread: look for a tect anywhere on the cell

  1. #1
    Board Regular
    Join Date
    Feb 2008
    Posts
    309
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default look for a tect anywhere on the cell

    i need to use the if statement to see if the word "John" is a cell in a column.
    How do i word the IF statement. Jon can be anywhere on the text on the cell

    thanks all

  2. #2
    Board Regular DanteAmor's Avatar
    Join Date
    Dec 2018
    Location
    México
    Posts
    6,187
    Post Thanks / Like
    Mentioned
    66 Post(s)
    Tagged
    14 Thread(s)

    Default Re: look for a tect anywhere on the cell

    Something like this:

     ABCD
    1    
    2    
    3data  any john data
    4data   
    5data   
    6data   
    7any john data   
    8data   
    9data   
    10data   
    11data   
    12data   

    CellFormula
    D3=IFERROR(VLOOKUP("*John*",A3:A12,1,0),"Dont exists")
    Regards Dante Amor

  3. #3
    Board Regular
    Join Date
    Feb 2008
    Posts
    309
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: look for a tect anywhere on the cell

    thanks
    but i just get
    =NAME?

  4. #4
    Board Regular
    Join Date
    Feb 2008
    Posts
    309
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: look for a tect anywhere on the cell

    BTW this is excel 2002
    thanks

  5. #5
    Board Regular DanteAmor's Avatar
    Join Date
    Dec 2018
    Location
    México
    Posts
    6,187
    Post Thanks / Like
    Mentioned
    66 Post(s)
    Tagged
    14 Thread(s)

    Default Re: look for a tect anywhere on the cell

    Try this

    =VLOOKUP("*John*",A3:A12,1,0)
    Regards Dante Amor

  6. #6
    Board Regular
    Join Date
    Feb 2008
    Posts
    309
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: look for a tect anywhere on the cell

    Success!
    thanks VERY much

  7. #7
    MrExcel MVP Rick Rothstein's Avatar
    Join Date
    Apr 2011
    Location
    New Jersey, USA
    Posts
    35,211
    Post Thanks / Like
    Mentioned
    92 Post(s)
    Tagged
    33 Thread(s)

    Default Re: look for a tect anywhere on the cell

    Quote Originally Posted by anon125 View Post
    BTW this is excel 2002
    You should mention this whenever you ask a question on a forum as it is an important fact we would need to know.
    Rick's "mini" blog... http://www.excelfox.com/forum/f22/
    .
    Want to post a small screen shot? See Part B here.

  8. #8
    Board Regular DanteAmor's Avatar
    Join Date
    Dec 2018
    Location
    México
    Posts
    6,187
    Post Thanks / Like
    Mentioned
    66 Post(s)
    Tagged
    14 Thread(s)

    Default Re: look for a tect anywhere on the cell

    Quote Originally Posted by anon125 View Post
    Success!
    thanks VERY much

    I'm glad to help you. Thanks for the feedback.
    Regards Dante Amor

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •