Excel help when using two different excel documents

[CoachMike22]

I have an excel with info I need to auto populate in a new excel. I will have an excel for example that will list names with ID#. I want to create a new document that when I enter a name it automatically pulls the ID# from existing excel. How do I automate that?

[#2]

@CoachMike22 

=Index(RangeWithIDs,Match(Name,RangeWithNames,0),1)