Populate column H with team manager when the team is selected in column F RRS feed

  • Question

  • I'm sure this can be done...

    The data for the validation list in of page 'Data'


    When the team is selected in column F, team 1 for arguments sake, the manager of that team is auto populated into cells in column H continuing row by row to the end of time

    This is my current formula


    however, when I do a blanket paste into column H, it goes like this...




    Column G on sheet 1 is fine, but the range needs to stay the same on sheet 'Data' otherwise it just breaks and I end up with




    Which is somewhat annoying

    Please help?

    Many Thanks


    Wednesday, June 14, 2017 8:55 AM


  • Hello Luke,

    Do you want to absolute reference the range? You could add "$" before the cell reference.



    Please let me know if I misunderstand.



    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact

    • Marked as answer by Luke Sykes Thursday, June 15, 2017 8:47 AM
    Thursday, June 15, 2017 2:30 AM