Forum Discussion
Solved
Help with if text and auto identify team leaders
Hi I have a long list of names with many repeats due to the tasks they do. How can I auto populate the Column to show their team leaders? The two Coloums. Are Name and team leader. I have a lis...
Much appreciated. This looks brilliant.
Thanks.
For my reference is there a Tutorial on the code used or a link.
Thanks.
For my reference is there a Tutorial on the code used or a link.
https://exceljet.net/index-and-match
Exceljet has lots of cool and intuitive tutorials you can learn many things from that site.
btw this is the main formula:
INDEX(teams[#All],MATCH(C97,teams[[#All],[team member]],0),2)
The rest is just to support the main formula
=IF(
ISBLANK(C97),
//Do this//
"Blank",
//Otherwise do this//
IF(
ISNA(INDEX(teams[#All],MATCH(C97,teams[[#All],[team member]],0),2)),
//Then display//
"Not Found",
//Otherwise do the main formula//
INDEX(teams[#All],MATCH(C97,teams[[#All],[team member]],0),2)
)
)