+ Reply to Thread
Results 1 to 3 of 3

IF cell = "Certiain text" then populate "Certain text"

  1. #1
    Registered User
    Join Date
    03-18-2020
    Location
    Dallas, USA
    MS-Off Ver
    2020
    Posts
    38

    IF cell = "Certiain text" then populate "Certain text"

    Hi Team!

    Please see the screenshot. I can't attach the entire excel file as it contains other sensitive data. (Sorry for inconvenience).

    This is what I am trying to do:

    If column E = the text "Bird Specialist", "Bird Specialist + Certified Trainer", "Certified Trainer", "Crew" or "Cross-Trained" then the cell in column G will populate with "CM" (please see column J for this reference".

    I have other criteria for column E (please see column J for reference):

    General Manager in Training to appear in column G as GMIT
    Shift Manager in Training to appear in column G as SMIT
    Operations Manager in Training to appear in column G as OMIT

    and there are more, but I think you get the picture.

    I tried using IF and IFS but I can't quite work it out. Can I have some help?
    Attached Images Attached Images
    Last edited by TSACov; 01-09-2021 at 07:01 PM.
    Thanks!
    - TSACov

  2. #2
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.83 (24031120))
    Posts
    8,739

    Re: IF cell = "Certiain text" then populate "Certain text"

    A lookup - if you are matching the exact cell
    so in G
    =vlookup(e2,$I$1:$J$20,2,false)

    otherwise load a spreadsheet example without the sensitive data
    Wayne
    if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here

    If you have a solution to your thread - Please mark your thread solved do the following: >
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

  3. #3
    Forum Expert
    Join Date
    05-29-2020
    Location
    NH USA
    MS-Off Ver
    365
    Posts
    2,103

    Re: IF cell = "Certiain text" then populate "Certain text"

    You should be able to populate the data using a vlookup formula.

    Something like

    Please Login or Register  to view this content.
    copied down from G2

+ 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. Replies: 4
    Last Post: 06-11-2017, 02:03 PM
  2. Replies: 1
    Last Post: 08-15-2014, 06:00 AM
  3. Date format of just "st" "nd" "rd" and "th" with text included
    By notrandom in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-10-2013, 05:45 PM
  4. Find "TEXT 1" in a range and enter "TEXT 2" in the adjacent cell
    By madreag in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-28-2013, 05:34 PM
  5. [SOLVED] If there is any text in column "A$" on "sheet1" then move cell to column "A$" on "sheet2"
    By ckgeary in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 06-27-2013, 08:28 PM
  6. Auto populate "text" in a cell depending on the "text" in another cell
    By shenoyhr in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-05-2011, 01:33 AM
  7. How can i copy value from "HTMLText"(EMBED("Forms.HTML:Text","")),using Macro
    By andrewyang in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-18-2010, 12:47 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