Tring to sort and match data

[carnut6657]

Hello new to the forum here and am struggling with trying to match and sort data.
I believe this to be a simple fix but I just can’t get the results I am looking for.

I basically have two columns of numbers one (O) has existing numbers from one list and the other column(X) has existing numbers from another list. I want to match and sort so the matching numbers are aligned in the same row so I know what numbers I need to add to make my new list. Each number is listed twice in each column.

I have used =IF(ISERROR(MATCH(O2,$X$2:$X$135,0)),"",O2) Witch shows me the matching numbers but I cannot get it to sort (with corresponding data) and put them all in the same rows. The first two rows (2,3) are the results I’m looking for, and I expect the non-matching numbers to be at the top or bottom of the list.

I have attached my work sheet.

Any help would be greatly appreciated

[mikeTRON]

Sort by column W and Column X and that should accomplish what you are trying to do.

[carnut6657]

mikeTRON,
Thank you I knew it was something simple, now I feel stupid! That worked Perfect I appreciate your help!

[mikeTRON]

Hey, sometimes I feel silly for suggesting such simple answers, but I always do because if it works then it is the easiest solution

Plus it helps that I am fairly familiar with almost all of the excel features so sometimes just mentioning something exists is enough to get someone on the path to a simple solution.