Looking for the correct formula

I have 2 Excel workbooks. Working with Excel 2016.

Workbook_1 consist of a complete list of names and contact information. In Workbook_2 I have a smaller list of names, all of which are in Workbook_1. I'm looking for a way to match the name in Workbook_2 Column A with the name in Workbook 1. In Workbook_2 Column B I would like the result to be the corresponding address found in Workbook_1.

Workbook_1 is Static. Workbook_2 is Dynamic.
Workbook_1.xlsx
Workbook_2.xlsx
Who is Participating?

0

Distinguished Expert - 2017Commented:
I am not sure, which Col you have Names & Address in Workbook_1, please try below formula in Workbook_2 B2 and drag down, if Col A in Workbook_1 is Names & Col B in Workbook_2 is Address.
``````=IFERROR(VLOOKUP(A2,Workbook_1!A:B,2,0),"")
``````
If possible please post dummy/sample workbook
0

Author Commented:
I have uploaded the sample files you requested
0

Use the following in cell B2 (and C2 for Return Address 2) of Workbook 2

=VLOOKUP(A2,[Workbook_1.xlsx]Sheet1!\$A\$2:\$C\$8,2,FALSE)

=VLOOKUP(A2,[Workbook_1.xlsx]Sheet1!\$A\$2:\$C\$8,3,FALSE)
0

Author Commented:
Thank you. This is just what I needed!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.