Forum Discussion

Clare1487's avatar
Clare1487
Copper Contributor
Dec 05, 2022
Solved

Linking excel workbooks

I have a report that I need to do monthly where one column will include staff members' names a random number of times.  I want to autofill the adjacent column with the name of their line manager.  How do I do this please?  (I have a table of the corresponding information, there are hundreds of staff members.)  Many thanks

excel

4 Replies

  • OliverScheurich's avatar
    OliverScheurich
    Gold Contributor
    Dec 05, 2022

    Clare1487 

    =INDEX($E$2:$E$27,MATCH(A2,$D$2:$D$27,0))

    You can try INDEX and MATCH as shown in the screenshot. Alternatives could be VLOOKUP or - if you work with Excel 2016 or later - XLOOKUP. Another alternative could be Power Query.