The issue that I am having is, is that I have names in one column and the team they belong to in another. I would like to auto populate the team the name belongs to. However, the way the names and teams are broken down I don't know how to make it work out. I have provided an example that would give a visual idea as well as an explanation
https://www.dropbox.com/s/6va9bdalqus0xfw/Team Search Listing.xlsx?dl=0
https://www.dropbox.com/s/6va9bdalqus0xfw/Team Search Listing.xlsx?dl=0