If I am compiling List 2 into list 1 using vlookup() by ID# and list 2
contains ID#s not on list 1, they are left off because there is no match.

Is there a better way to put the 2 lsits together so that they are joined
and not matched up 1 list to the other?

--
Thanks As Always
Rip