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 [b]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


--
Dev4me
------------------------------------------------------------------------
Dev4me's Profile: http://www.excelforum.com/member.php...o&userid=29709
View this thread: http://www.excelforum.com/showthread...hreadid=496806