Results 1 to 6 of 6

Look up a part of the content of a cell

Threaded View

  1. #1
    Registered User
    Join Date
    02-22-2007
    Posts
    9

    Look up a part of the content of a cell

    Hi there, who can help me with this challange??

    In the example below you find two columns A and B. In Column C I would like to show (via "yes" or "no" whether the content of the cells in Column B can be retreived - even if it doesn't match the full content - in Column A.

    e.g.:
    The content of B4 is "ert", the value in C4 is "yes" as "ert" can be found in A6.

    Is there a formula that I can use for this?

    Row Column A Column B Column C
    1 abc/def/efg def yes
    2 abc/def/efg abc yes
    3 abc/def/efg efg yes
    4 abc/def/efg ert yes
    5 abc/def/efg ade no
    6 abc/def/efg/ert bc yes
    7 abc/def/efg def yes
    8 abc/def/efg efg yes
    9 abc/def/efg zzz no
    10 abc/def/efg c/e yes
    11 abc/def/efg c/d yes

    Thanks already for those who can help me!
    Damien
    Last edited by VBA Noob; 02-22-2007 at 11:38 AM.

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