Hi all
I have two worksheets
2 columns each

The first sheet has ID and Name Column
for example:
ID              NAME
193948          Michael
684588          John
535279          Luke
098734          Matthew
my 2nd sheet

ID         NAME
           Michael
           John
           Luke
           Matthew
How do i use the first sheet to match up the names on the 2nd sheet
and ultimately copy the ID numbers onto the 2nd sheet?
This is just a simplified example. There are thousands of entries.
Thank you if you have any ideas