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...
Please find some example below.
Thank you
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
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
Please find a data set. To confirm I am after a formula in D2 to auto populate based on the entry in WC column (C) based on the team leader for that person in WC column. This team info is in sheet two.
Hope this is clear.
Many thanks,
The two most important columns in sheet1 are non existent. Are the ID and Team Leaders column unavailable because those columns are the ones that will make your life easier.
which list are the team leader and how can I tell which one is the team leader for which group?
Please elaborate
- 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.