verifying one cell and pasting number next to it

[Dev4me]

Hi all
I have two worksheets
2 columns each

The first sheet has ID and Name Column
for example:

Code:
--------------------
ID[/B] NAME
193948 Michael
684588 John
535279 Luke
098734 Matthew
--------------------


my 2nd sheet


Code:
--------------------
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

 

[Tom Ogilvy]

Look in Excel Help (not VBA) at the Index and Match Function

=Index(Sheet1!$A:$A,Match(B1,Sheet1!$B:$B,0),1)

Put in A2 of the second sheet and drag fill down the column.