+ Reply to Thread
Results 1 to 2 of 2

IF function to check for words

  1. #1
    Registered User
    Join Date
    07-16-2014
    Location
    the hague, netherlands
    MS-Off Ver
    14.0
    Posts
    1

    IF function to check for words

    Dear all,

    I've been scanning for a few hours now but can't find a solution. I've got a column with words of a group of words. Like: A2: "conflicts of interest" A3: "regulations".

    Then I've got a cell that contains text like: B1 "the regulations for conflicts of interest within this firm are the following bla bla bla"

    Now I would like to assign a value of to for instance B2 if B1 contains the exact content of A2. Then I would like to expand this formula keeping B1 as a resource.

    Can anyone help me out?

  2. #2
    Valued Forum Contributor
    Join Date
    04-22-2014
    Location
    Auckland, New Zealand
    MS-Off Ver
    Office 365 (work) and Excel 2013 (home)
    Posts
    1,167

    Re: IF function to check for words

    In B2 try this: =IF(ISERROR(FIND(A2,B1)),"",[Value you want assigned]). Just replace the square brackets with the value you want assigned, or a reference to a cell containing that value.
    Please add reputation by clicking on the * if I have helped.
    Please mark the thread SOLVED if your issue has been resolved.
    Thanks, Glenn.

+ 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. check if contains words
    By Leon V (AW) in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-04-2013, 05:33 AM
  2. [SOLVED] Need to perform a simple check with letters in two words... again!
    By nvembos in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-27-2012, 05:34 AM
  3. [SOLVED] Macro to check for words in a given paragraph !
    By kinirobin in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 08-21-2012, 12:58 PM
  4. Excel 2007 : check if cellcontains either of two words
    By gregallen in forum Excel General
    Replies: 3
    Last Post: 06-02-2010, 05:12 AM
  5. Macro to check for duplicate words in a cell
    By pharri11 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-07-2007, 05:22 AM

Tags for this Thread

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