Hi all
I have two worksheets
2 columns each
The first sheet has ID and Name Column
for example:
my 2nd sheetID NAME 193948 Michael 684588 John 535279 Luke 098734 Matthew
How do i use the first sheet to match up the names on the 2nd sheetID NAME Michael John Luke Matthew
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
Bookmarks