Forum Discussion
Managers Reports List
I have a list of people in column A and a list of managers in column B of a table in an excel spreadsheet. Each month I run a separate series of reports, from a database,which only reports people and...
Let's say the sheet with the list is named Manager List.
On other sheets: let's say you have names in A2 and down.
In B2, enter the formula
=XLOOKUP(A2, 'Manager List'!$A:$A, 'Manager List'!$B:$B, "")
or if you don't have Microsoft 365 or Office 2021:
=IFERROR(VLOOKUP(A2, 'Manager List'!$A:$B, 2, FALSE), "")
Then fill down.
Thanks! I'll give this a try.