+ Reply to Thread
Results 1 to 12 of 12

Trying to automatically add text to a cell based on the text values in two adjacent cells

  1. #1
    Registered User
    Join Date
    04-23-2015
    Location
    portland, oregon
    MS-Off Ver
    2013
    Posts
    5

    Trying to automatically add text to a cell based on the text values in two adjacent cells

    I have a spreadsheet that has drop down values in columns D and E (use can select high or low). Based on what is selected in those two columns I want to automatically populate text in column F.

    Here are a couple of specific examples:
    When D and E are both Low then F should be populated with the words Monitor (Low Interest, Low Authority)
    When D and E are High and Low then F should be populated with the words Keep Informed (High Interest, Low Authority)

    I only have 4 permutations of this.

    Thanks for any help you can provide.
    Kate

  2. #2
    Valued Forum Contributor
    Join Date
    02-07-2013
    Location
    Philippines
    MS-Off Ver
    Excel 2007, 2010
    Posts
    533

    Re: Trying to automatically add text to a cell based on the text values in two adjacent ce

    kate try this formula and let me know if it works:

    =IF(OR(D1="",E1=""),"",IF(AND(D1="Low",E1="Low"),"Monitor (Low Interest, Low Authority)",IF(AND(D1="High",E1="Low"),"Keep Informed (High Interest, Low Authority)")))
    If I've helped U pls click on d *Add Reputation

  3. #3
    Registered User
    Join Date
    04-20-2015
    Location
    Egypt
    MS-Off Ver
    2010
    Posts
    22

    Re: Trying to automatically add text to a cell based on the text values in two adjacent ce

    Could you please attach the worksheet

  4. #4
    Registered User
    Join Date
    04-23-2015
    Location
    portland, oregon
    MS-Off Ver
    2013
    Posts
    5

    Re: Trying to automatically add text to a cell based on the text values in two adjacent ce

    I have attached the sample spreadsheet. You can see the 4 options for column F based on what is selected in columns D and E.
    Attached Files Attached Files

  5. #5
    Valued Forum Contributor
    Join Date
    02-07-2013
    Location
    Philippines
    MS-Off Ver
    Excel 2007, 2010
    Posts
    533

    Re: Trying to automatically add text to a cell based on the text values in two adjacent ce

    did you try this formula:

    =IF(OR(D1="",E1=""),"",IF(AND(D1="Low",E1="Low"),"Monitor (Low Interest, Low Authority)",IF(AND(D1="High",E1="Low"),"Keep Informed (High Interest, Low Authority)")))

  6. #6
    Valued Forum Contributor
    Join Date
    02-07-2013
    Location
    Philippines
    MS-Off Ver
    Excel 2007, 2010
    Posts
    533

    Re: Trying to automatically add text to a cell based on the text values in two adjacent ce

    This formula should work:

    =IF(OR(D2="",E2=""),"",IF(AND(D2="Low",E2="Low"),"Monitor (Low Interest, Low Authority)",IF(AND(D2="High",E2="Low"),"Keep Informed (High Interest, Low Authority)",IF(AND(D2="Low",E2="High"),"Keep Satisfied (Low Interest, High Authority)",IF(AND(D2="High",E2="High"),"Manage Closely (High Interest, High Authority)")))))

  7. #7
    Registered User
    Join Date
    04-23-2015
    Location
    portland, oregon
    MS-Off Ver
    2013
    Posts
    5

    Re: Trying to automatically add text to a cell based on the text values in two adjacent ce

    Thanks. It didn't work for me but it could be operator error. Where do I insert the formula because I must not be doing it correctly. Have you tried it with the spreadsheet that I attached?

  8. #8
    Valued Forum Contributor
    Join Date
    02-07-2013
    Location
    Philippines
    MS-Off Ver
    Excel 2007, 2010
    Posts
    533

    Re: Trying to automatically add text to a cell based on the text values in two adjacent ce

    yes just paste it on cell F2

  9. #9
    Registered User
    Join Date
    04-23-2015
    Location
    portland, oregon
    MS-Off Ver
    2013
    Posts
    5

    Re: Trying to automatically add text to a cell based on the text values in two adjacent ce

    Yes that's what I tried but it didn't work for me. Is there anything that I need to paste/do in addition to pasting in on cell F2? Were you able to get this to work in the sample spreadsheet I attached?

  10. #10
    Valued Forum Contributor
    Join Date
    02-07-2013
    Location
    Philippines
    MS-Off Ver
    Excel 2007, 2010
    Posts
    533

    Re: Trying to automatically add text to a cell based on the text values in two adjacent ce

    Go to Formulas > Calculation Options and see if your calculations are set to Automatic

    Yes I tried it in your sheet and it worked.

  11. #11
    Registered User
    Join Date
    04-23-2015
    Location
    portland, oregon
    MS-Off Ver
    2013
    Posts
    5

    Re: Trying to automatically add text to a cell based on the text values in two adjacent ce

    Got it now. Thanks so much.

  12. #12
    Valued Forum Contributor
    Join Date
    02-07-2013
    Location
    Philippines
    MS-Off Ver
    Excel 2007, 2010
    Posts
    533

    Re: Trying to automatically add text to a cell based on the text values in two adjacent ce

    Please marked this thread as solved and consider adding a reputation as a thank you.

+ 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. Gathering the sum of cells based on the text in the adjacent cell
    By avidcat in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 02-19-2014, 03:58 PM
  2. Formula to identify part of a text in cell from range of cells & insert adjacent cell text
    By Novicebutnotforlong in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 11-19-2013, 02:11 AM
  3. How to: Auto-pop text based on text of adjacent cell
    By BobWiley85 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-11-2013, 04:44 PM
  4. Replies: 2
    Last Post: 09-07-2013, 07:50 PM
  5. Conditional formatting of adjacent cells based on text in cell
    By elderain@gmail.com in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-07-2006, 07:20 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1