+ Reply to Thread
Results 1 to 4 of 4

If cell contains a specific text then returns a text to specific cell

  1. #1
    Registered User
    Join Date
    07-02-2018
    Location
    Bangkok, Thailand
    MS-Off Ver
    2016 MSO (16.0.9330.2124) 64 bit
    Posts
    2

    If cell contains a specific text then returns a text to specific cell

    I want to search for a specific text within a specific roll, and if it's found, then it would return a specific text to a specific cell.

    To say, I want to return the word "Good job" to B1 if there is the word "Office" in A1 repeatedly all the way down to the 4th row, and the formula must be contained in C1 or D1

    Because I want to return something else for the word "Home" reasonably

    A B C D
    1 Office Good job
    2 Office Good job
    3 Home
    4 Office Good job

    Thanks :)

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    50,213

    Re: If cell contains a specific text then returns a text to specific cell

    Hi, welcome to the forum

    If you only have a few options to choose from (say, 4 at most), you could use something like this...
    =if(A1="Office","good job",if(A1="Home","blah", if(A1="cat","Dog"."")))

    If, on the other hand, you have many options, it would probably be better to use VLOOKUP
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    07-02-2018
    Location
    Bangkok, Thailand
    MS-Off Ver
    2016 MSO (16.0.9330.2124) 64 bit
    Posts
    2

    Re: If cell contains a specific text then returns a text to specific cell

    Thank you for the reply! Your ans is very helpful. But I'm a newbie here, and I have a very specific condition that the formula must be contained in the column C or D. Do you kindly have another advice please?
    Last edited by hbtpoprock; 07-03-2018 at 12:19 AM.

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    50,213

    Re: If cell contains a specific text then returns a text to specific cell

    So put my suggested formula in either C or D?

+ 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. [SOLVED] Open/Load TEXT file with Specific Date and start at specific Cell
    By chergian in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-09-2017, 09:29 AM
  2. [SOLVED] If a cell contains text insert specific text in specific cells in row
    By muss1210 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-18-2017, 10:51 AM
  3. [SOLVED] VBA to Find Specific Text, then Copy range to next open cell under specific text
    By Remotruker in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-24-2015, 10:59 AM
  4. Replies: 2
    Last Post: 08-05-2013, 07:32 PM
  5. Replies: 3
    Last Post: 07-12-2013, 09:17 AM
  6. [SOLVED] Formula with specific text that inserts value from BESIDE cell with specific text.
    By jtmann in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 08-13-2012, 09:24 AM
  7. Replies: 1
    Last Post: 06-22-2012, 02:18 PM

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