Forum Discussion

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. Ho...

excel

OliverScheurich
Dec 05, 2022
Clare1487
=XLOOKUP(A2,$D$2:$D$81,$E$2:$E$81)
With Office 365 you can apply XLOOKUP.
staff member.xlsx38 KB

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.

Clare1487
Copper Contributor
Dec 05, 2022
OliverScheurich
Thank you, your screenshot looks like exactly what I need. I am receiving errors with the formula but will keep trying it, I'm on excel version 2210 with microsoft 365.
- OliverScheurich
  Gold Contributor
  Dec 05, 2022
  Clare1487
  =XLOOKUP(A2,$D$2:$D$81,$E$2:$E$81)
  With Office 365 you can apply XLOOKUP.
  staff member.xlsx38 KB
  - Clare1487
    Copper Contributor
    Dec 07, 2022
    Thank you so much for your time! That works perfectly.