On Oct 8, 6:49 pm, gary wrote:
The first list has 2,500 part-numbers; the second list has 1 million
part-numbers.

How can I move the part-numbers in the first list so they are next to
the matching part-numbers in the second list?

Don't have 2007 (yet), but couldn't you just use a VLOOKUP formula to
get it's match? Or am I oversimplifying the issue?