This might suffice
In C2: =IF(ISNUMBER(MATCH(A2,B:B,0)),A2,"")
Copy down

If desired, kill the formulas with an "in-place" copy n paste special as
values, then delete col B
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"L Brandon" wrote:
I need to combine two lists of parts numbers - both list are not identical
they share 80% of the same part numbers but I need the data to line up with
the master list. I need the numbers to line up across from each other

Thanks in advance

Master # 2nd list
1 2
2 4
3 6
4 8
5 10
6
7
8
9
10