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