SOLVED

Formula to match names in two columns and copy team number in next column

Copper Contributor

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.

 

2 Replies
best response confirmed by Snorket27 (Copper Contributor)
Solution

@Snorket27 

You can use VLOOKUP to do that:

 

Screenshot 2023-12-31 at 12.51.00 PM.png

1 best response

Accepted Solutions
best response confirmed by Snorket27 (Copper Contributor)
Solution

@Snorket27 

You can use VLOOKUP to do that:

 

Screenshot 2023-12-31 at 12.51.00 PM.png

View solution in original post