I have two spreadsheets. One has a list of names in one column and an ID
number in another column. The other sheet has a list of names in one
column and a second ID number in the other.

I need to get the names in one column, the first ID number in the
second, and the other ID in the third column. Here comes the problem.
There are more than 2000 rows in the first sheet and more than 6500
rows in the second, so there are going to be names that won't get both
numbers. Some will get only the first ID and some will only get the
second ID. I'm guessing about 2000 lines will have all three items in
them.

So, lay it on me, gurus! This has me beat!


--
JFALK
------------------------------------------------------------------------
JFALK's Profile: http://www.excelforum.com/member.php...o&userid=24728
View this thread: http://www.excelforum.com/showthread...hreadid=382937