Results 1 to 14 of 14

Auto-population Troubles

Threaded View

  1. #1
    Registered User
    Join Date
    08-28-2011
    Location
    St. Louis
    MS-Off Ver
    Excel 2007
    Posts
    35

    Auto-population Troubles

    Good Morning Excel Experts,

    Hope this thread finds you well. I am trying to form an Excel Worksheet that will automate comments in one Column based upon what letter is entered into Column C. The formula I have so far is:

    =IF(C2="D","Account Requiring Assist Code Adjustment",IF(C2="E","Adjust Source Code",IF(C2="F","Adjust LM Counselor",IF(C2="G","Adjust Plan Type",IF(C2="H","Email Assigned Rep","")))))

    However, I am looking for a non-VBA way to have it where the user can enter multiple letters into Column C and have multiple comments appear.

    For Example, if Column C had D, E & H entered. The comments would appear as, “Account Requiring Assist Code Adjustment,” “Adjust Source Code,” and “Email Assigned Rep.”

    Would the entry method in Column C to obtain multiple comments need to be entered with a comma and no space? A semicolon and no space? A comma with a space?
    Last edited by dreinisch; 10-10-2012 at 12:57 PM. Reason: Solved

Thread Information

Users Browsing this Thread

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

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