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

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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
0

Experts Exchange Solution brought to you by