Extract info from Excel

Hello, I wonder if you could please help me.
I thought this would be something simple but after an exhaustive search and using filters and Vllookup I have been unsuccessful making this work, I'm hoping this will be something you can help with.
I have 2 excel workbooks, one contains a master list of 1000+ stores with store numbers and addresses, the second contains 200 some store numbers the customer would like to ship to (no addresses). Is there a way to have excel pull the info. from the master list using the 200+ store numbers in the list they want to ship to?
I thank you in advance for any help you can give me,
Respectfully,
Amanda