Hi
I am trying to do the following:
On Sheet3, I have a table, the table headers are Names of Team Leaders I.e. TeamA, TeamB, TeamC etc.
The table lists the names of the team members under each leader I.e. TeamA has MemberAA, MemberAB, MemberAC etc.
On Sheet2, I have the list of all the Members in ColumnA
In ColumnB, I would like to input a formula that will search the table on Sheet3 and return the Header/Team Leaders name they are assigned to.
I have tried Index&Match, and XLookup and nothing will search the whole table and return the corresponding Team Leader name.
Can anyone please help.
Regards
I am trying to do the following:
On Sheet3, I have a table, the table headers are Names of Team Leaders I.e. TeamA, TeamB, TeamC etc.
The table lists the names of the team members under each leader I.e. TeamA has MemberAA, MemberAB, MemberAC etc.
On Sheet2, I have the list of all the Members in ColumnA
In ColumnB, I would like to input a formula that will search the table on Sheet3 and return the Header/Team Leaders name they are assigned to.
I have tried Index&Match, and XLookup and nothing will search the whole table and return the corresponding Team Leader name.
Can anyone please help.
Regards