Sorting Multiple Columns -

[L Brandon]

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

 

[Max]

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

 

[Dave]

Hi LB,
Try this.
If your Master list starts in A1, and your 2nd list starts in B1:
Place this formula in C1 and fill down to the last row of data in Column A.
=IF(ISERROR(MATCH(A1,$B$1:$B$5,0)),"",INDEX($B$1:$B$5,MATCH(A1,$B$1:$B$5,0)))
Regards - Dave.