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...
To elaborate the column C and D are my focus. A and B are purely just information for me.
If you look in sheet 2 you will see the groups and the team leader in bold.
To clarify I’m looking to populate Column D based on the name in column C.
Thank you.
If you look in sheet 2 you will see the groups and the team leader in bold.
To clarify I’m looking to populate Column D based on the name in column C.
Thank you.
- Thank you for clarification and changing the original template.
Thank you again! - Sorry If I was not clear.
Can you delete all the attachments please in the thread.
Thank you. - copy that
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)
)
)- Additionally is the file attached above possible to delete as it contains some real data and would appreciate if the code was pasted for any reference.
Many thanks - Much appreciated. This looks brilliant.
Thanks.
For my reference is there a Tutorial on the code used or a link.