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 list of all the team leaders and who is in their team on a different sheet.
Thank you!
The two Coloums. Are
Name and team leader.
I have a list of all the team leaders and who is in their team on a different sheet.
Thank you!
15 Replies
Can you please share some file with raw data? It will be easier to assist you.
- Please find some example below.
Thank you- you provided us with nine names and two team leader names.
How are we to help you auto populate using a formula if the formula has nothing to point to? you need to share that data set so we can suggest what formulas to use to make your life a bit easier but without that data set your guess is as good as ours
