none
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'

    Aim...

    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


    =VLOOKUP(G2,Data!B10:C26,2,FALSE)


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


    =VLOOKUP(G2,Data!B10:C26,2,FALSE)

    =VLOOKUP(G3,Data!B11:C27,2,FALSE)

    =VLOOKUP(G4,Data!B12:C28,2,FALSE)


    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


    NA#

    NA#

    NA#


    Which is somewhat annoying

    Please help?


    Many Thanks


    Luke

    Wednesday, June 14, 2017 8:55 AM

Answers

  • Hello Luke,

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

    E.g.

    =VLOOKUP($G$2,Data!$B$10:$C$26,2,FALSE)

    Please let me know if I misunderstand.

    Regards,

    Celeste


    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 MSDNFSF@microsoft.com.

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