User Profile
Snorket27
Copper Contributor
Joined Dec 30, 2023
User Widgets
Recent Discussions
Formula to match names in two columns and copy team number in next column
Sorry if the subject is confusing. I have an excel spreadsheet with a list of names (List 1). In another spreadsheet I have a another list of names with their team number (List 2). There is an overlap in the names in List 1 and 2. I copied List 2 into the same sheet as List 1. What I want to do is find the names that appear in both lists, and copy their team number to List 1. So something like this: List 1 List 2 name team name team Amy Peter Team 1 James Rob Team 3 Peter Amy Team 2 James Team 1 I want to fill up the team column in List 1. I know there's a find duplicates function, but i don't know how to use it to copy the values of one cell to another. Any help will be appreciated.Solved2.7KViews0likes2Comments
Recent Blog Articles
No content to show