+ Reply to Thread
Results 1 to 10 of 10

Formula that will populate a cell after another cell is populated

  1. #1
    Registered User
    Join Date
    01-01-2013
    Location
    United States
    MS-Off Ver
    Excel 2013
    Posts
    15

    Formula that will populate a cell after another cell is populated

    I have been looking everywhere for a formula that will help me do this:

    When I type the word "PREC" into a cell on rows 26-42 I would like row 14 to automatically populate with the initials of the person scheduled.

    I cannot have the formula be in row 14 or anywhere else on the schedule really because I have to manually enter data and that will erase my formula.

    I have been thinking about this for days! Please help
    Attached Files Attached Files

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,443

    Re: Formula that will populate a cell after another cell is populated

    Hi
    an iNDEX/MATCH combination will probably be the solution. OTH as you are using merged cells, which are nothing but trouble, I strongly advise you remove them before any solution can be offered

  3. #3
    Registered User
    Join Date
    01-01-2013
    Location
    United States
    MS-Off Ver
    Excel 2013
    Posts
    15

    Re: Formula that will populate a cell after another cell is populated

    I am sorry, I was unaware that merged cells can cause a problem. I have removed the merged cells on rows 14 & 15. I really appreciate any help you can give me, this schedule has been a headache for years. Thanks!
    Attached Files Attached Files

  4. #4
    Banned User!
    Join Date
    10-14-2006
    Posts
    1,211

    Re: Formula that will populate a cell after another cell is populated

    I will help you. If you remove all the merged cells.

  5. #5
    Registered User
    Join Date
    01-01-2013
    Location
    United States
    MS-Off Ver
    Excel 2013
    Posts
    15

    Re: Formula that will populate a cell after another cell is populated

    I have removed all of the merged cells. Can you please explain to me why that was necessary.

    Thanks for your help!
    Attached Files Attached Files

  6. #6
    Banned User!
    Join Date
    10-14-2006
    Posts
    1,211

    Re: Formula that will populate a cell after another cell is populated

    See the attached
    Attached Files Attached Files

  7. #7
    Registered User
    Join Date
    01-01-2013
    Location
    United States
    MS-Off Ver
    Excel 2013
    Posts
    15

    Re: Formula that will populate a cell after another cell is populated

    Thank you so much, I really appreciate you taking the time to help me. One thing I realized is that sometimes I have to input other initials in row 14 that are not on the schedule anywhere which would erase the formula. Is it possible to not have the formula in row 14?

  8. #8
    Banned User!
    Join Date
    10-14-2006
    Posts
    1,211

    Re: Formula that will populate a cell after another cell is populated

    Quote Originally Posted by SerraAngel View Post
    Thank you so much, I really appreciate you taking the time to help me. One thing I realized is that sometimes I have to input other initials in row 14 that are not on the schedule anywhere which would erase the formula. Is it possible to not have the formula in row 14?
    You need VBA code. Someone might help you on this.

  9. #9
    Registered User
    Join Date
    01-01-2013
    Location
    United States
    MS-Off Ver
    Excel 2013
    Posts
    15

    Re: Formula that will populate a cell after another cell is populated

    Ok thanks, I dont know much about VBA but I did think of another idea. I added some additional rows to the schedule with all other potential initials that I might use and I will just hide them before printing.

    One last question. Sometimes I dont need a "PREC" to be populated in a column. Currently if I remove "PREC" from the column, #N/A appears on row 14. Is there a way to modify the formula so row 14 will say "0 RES" instead of #N/A?

    =MID(INDEX($C$20:$C$43,MATCH("PREC",J$20:J$43,0)),2,2)

  10. #10
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,443

    Re: Formula that will populate a cell after another cell is populated

    Perhaps
    Please Login or Register  to view this content.
    for pre 2007 versions

    Please Login or Register  to view this content.
    for the others

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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