Forum Discussion

Copper Contributor

Sep 20, 2021

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...

excel

Formulas and Functions

Yea_So
Sep 22, 2021
kaymiah

Here you go:

File attached

Juliano-Petrukio

Bronze Contributor

Sep 20, 2021

kaymiah

Can you please share some file with raw data? It will be easier to assist you.

kaymiah

Copper Contributor

Sep 20, 2021

Please find some example below.
Thank you

Yea_So
Bronze Contributor
Sep 21, 2021
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
- kaymiah
  Copper Contributor
  Sep 21, 2021
  Yea_So
  
  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,
  - Yea_So
    Bronze Contributor
    Sep 21, 2021
    kaymiah
    
    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