+ Reply to Thread
Results 1 to 1 of 1

Formula - Words from One Cell Appear in Another Returns Result

  1. 06-29-2021, 10:40 AM #1
    Sunny999
    Sunny999 is offline
    Registered User
    Join Date
    06-29-2021
    Location
    New York
    MS-Off Ver
    365
    Posts
    1

    Formula - Words from One Cell Appear in Another Returns Result

    I have a spreadsheet that has Full Job Titles in column A. Column B Persona needs to be populated. Column D Title contains words that may appear in Column A. If the words in Column D appear in Column A populate Column B with the Persona in Column E. Please see attached for example and what the result should look like. I have many lines of data to populate. Looking for a formula that will do this.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Formula that returns adjacent cell depending of result of diferent cells
    By Flip_Flop in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 07-27-2017, 08:50 AM
  2. My formula returns a result but the cell displays a zero?
    By Excel User in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 05-05-2017, 10:54 AM
  3. [SOLVED] returns a result and removed the formula
    By Hanif13 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-30-2014, 02:00 AM
  4. [SOLVED] pop up box when formula result returns a certain value
    By Kat81 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-25-2014, 06:52 PM
  5. [SOLVED] If result of formula in one cell returns 0, use value from another cell
    By JJGF in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 11-11-2013, 05:58 PM
  6. formula that searches words in a string and returns column next to the occurance
    By jme851 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-04-2013, 02:09 PM
  7. isblank & vlookup formula returns #n/a result and incorrect result
    By helpmeplease333 in forum Excel General
    Replies: 5
    Last Post: 05-06-2012, 11:41 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1