SOLVED

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

Copper Contributor

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

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

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

You can use VLOOKUP to do that:

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

It works! Thanks so much!
1 best response

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

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

You can use VLOOKUP to do that: