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.
Who is Participating?
Matt NicholasConnect With a Mentor Business AnalystCommented:
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.

Open in new window

If possible please post dummy/sample workbook
JohnAuthor Commented:
I have uploaded the sample files you requested
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


Return Address 2

JohnAuthor Commented:
Thank you. This is just what I needed!
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.