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
JohnAsked:
Who is Participating?
 
Matt NicholasConnect With a Mentor Business AnalystCommented:
0
 
ShumsDistinguished 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),"")

Open in new window

If possible please post dummy/sample workbook
0
 
JohnAuthor Commented:
I have uploaded the sample files you requested
0
 
Matt NicholasConnect With a Mentor Business AnalystCommented:
Use the following in cell B2 (and C2 for Return Address 2) of Workbook 2

Return Address 1

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

Return Address 2

=VLOOKUP(A2,[Workbook_1.xlsx]Sheet1!$A$2:$C$8,3,FALSE)
0
 
JohnAuthor 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.

All Courses

From novice to tech pro — start learning today.