Results 1 to 7 of 7

UDF for finding text in cell from a list of text

Threaded View

  1. #1
    Forum Contributor
    Join Date
    01-25-2011
    Location
    Virginia
    MS-Off Ver
    Excel 2016
    Posts
    166

    UDF for finding text in cell from a list of text

    I need a UDF to determine if a cell has any of several words from a list and return one phrase if true and another if false

    Example:
    A1: The big red apple tree
    A2: The big apple tree

    B1: Color
    B2:Blue
    B3:Red
    B4: Yellow
    etc.

    so for A1 it would look for any of the words in column B and return "COLOR" since Red is in A1 and in column b

    For A2 it would return "NO COLOR", since none of the words in column B are in the string in A2.

    Thanks in advance,

    Tom
    Last edited by tom.hogan; 01-26-2011 at 09:36 PM.

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