+ Reply to Thread
Results 1 to 4 of 4

Populating cell with different values based on 1-5 different cells having text

  1. #1
    Registered User
    Join Date
    06-18-2022
    Location
    Ohio
    MS-Off Ver
    Office 365 Online
    Posts
    22

    Populating cell with different values based on 1-5 different cells having text

    What function or layered functions am I looking for here? I'm needing cell DQ2 to populate either A, AB, ABC, ABCD, or ABCDE based on whether there is text in cells BM2-BQ2 respectively. Examples:

    If BM2 is the only cell in BM2-BQ2 with text, then DQ2 populates "A".
    If BM2 and BN2 have text, then DQ2 populates "AB".
    If BM2-BQ2 all have text, then DQ2 populates "ABCDE".

    Of note, BN2 will never have text if BM2 doesn't and so on. So you'll never have "ACE" or anything skipping letters.

    I was able to make DQ2 look at just BM2, but am not sure how to expand that to look at the rest of the cells as well.
    Thanks in advance!
    Attached Files Attached Files

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,974

    Re: Populating cell with different values based on 1-5 different cells having text

    Try:
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Registered User
    Join Date
    06-18-2022
    Location
    Ohio
    MS-Off Ver
    Office 365 Online
    Posts
    22

    Re: Populating cell with different values based on 1-5 different cells having text

    So simple! Thank you!

  4. #4
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,974

    Re: Populating cell with different values based on 1-5 different cells having text

    You're welcome. Thanks for the rep.

    So simple! Thank you!
    Always is, once you know

+ 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: 9
    Last Post: 06-08-2016, 10:13 AM
  2. Populating # values based on multiple text answers
    By g_francescal in forum Excel General
    Replies: 5
    Last Post: 08-05-2015, 03:54 PM
  3. Replies: 11
    Last Post: 04-30-2015, 05:35 PM
  4. Replies: 12
    Last Post: 01-13-2015, 09:30 AM
  5. Populating some cells based on the text in another. Also, cross referencing?
    By zaphodbblbrux in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-21-2013, 02:50 PM
  6. [SOLVED] Populating mutiple cells based on specific values
    By Grillpan in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-14-2012, 09:12 AM
  7. Replies: 8
    Last Post: 07-12-2012, 02:14 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