Overclock.net banner

MS Excel: Comparing names in 2 different workbooks and returning a record

249 views 3 replies 2 participants last post by  subz3ro 
#1 ·
Hey guys!

Quick question. Ive been trying to google the results but i cannot find the right way to solve my issue.

Basically, i have 2 Excel workbooks. Lets call them WB1 and WB2. WB1 is basically a concise version of WB2. They contain details of my clients such as names, address and contact.

What i need to do is to:

1. Compare the names in WB1 with WB2
2. Return a particular cell from WB2 into WB1.

Any ideas how i can go about doing this? Im stumped.
frown.gif
 
See less See more
1
#2 ·
Quote:
Originally Posted by crazydj View Post

Hey guys!

Quick question. Ive been trying to google the results but i cannot find the right way to solve my issue.

Basically, i have 2 Excel workbooks. Lets call them WB1 and WB2. WB1 is basically a concise version of WB2. They contain details of my clients such as names, address and contact.

What i need to do is to:

1. Compare the names in WB1 with WB2
2. Return a particular cell from WB2 into WB1.

Any ideas how i can go about doing this? Im stumped.
frown.gif
What are you trying to achieve? Being more specific would help a lot. Are you trying to look for a specific name from data contained in both workbooks and then return it in a field somewhere? I don't think you can do it between workbooks, unless you mean worksheets.

This might help, http://www.k2e.com/tech-update/tips/722-tips-comparing-two-workbooks-excel2013-compare-files-feature
 
#3 ·
Quote:
Originally Posted by subz3ro View Post

What are you trying to achieve? Being more specific would help a lot. Are you trying to look for a specific name from data contained in both workbooks and then return it in a field somewhere? I don't think you can do it between workbooks, unless you mean worksheets.

This might help, http://www.k2e.com/tech-update/tips/722-tips-comparing-two-workbooks-excel2013-compare-files-feature
1. I have a modified client list in WB1. It does not contain the cellphone numbers of my clients.
2. I have the original client list in WB2, with all my clients' data. It contains cellphone numbers of my clients.
3. I want to use the names in WB1, compare with the list in WB2 and return the matching cellphone numbers from WB2 into WB1.

If i do it between worksheets, any ideas what would the formula be like?
 
#4 ·
Quote:
Originally Posted by crazydj View Post

1. I have a modified client list in WB1. It does not contain the cellphone numbers of my clients.
2. I have the original client list in WB2, with all my clients' data. It contains cellphone numbers of my clients.
3. I want to use the names in WB1, compare with the list in WB2 and return the matching cellphone numbers from WB2 into WB1.

If i do it between worksheets, any ideas what would the formula be like?
This would be the formula, =INDEX(Sheet2!B:B,MATCH(Sheet1!A:A, Sheet2!A:A, 0))

Here is an example workbook with the formula working. The order of names doesn't matter, but it has to be an exact match.

indexformula.xlsx 10k .xlsx file
 

Attachments

This is an older thread, you may not receive a response, and could be reviving an old thread. Please consider creating a new thread.
Top