Formula to find and relocate discontinuous series of numbers

Hi It Has Been A While,But finally granted company access to the internet...yeah!!My dilemma I have a column of numbers all in XXXX format integers with four place holders. I want to select 100 specific numbers from a column (column 3) and the adjacent number in column 2 and copy them (from column 2 & 3) to another column on the same worksheet/book. Attached is the worksheetThank you for your assistance...mojave1

Thank you for the immediate response; I need to locate the 100 four digit numbers contained or shown in column 1, in column 2 and its companion or associated number in column 3.....then copy the results in any column to the right on the same worksheet...Thanks again....Marty

The only way I know to do this is to use an advanced filter.
First you have to create another column in E with a title of Col4.
Enter in E2 the formula: =C2-5980000.
Copy it down the column to the last number.
In H1 type Col2
In I1 gype Col3
select H1:I1 and give it the name Extract
Change A1 to Col4
Select all the data in A and give it the name Criteria
Change C1 & D1 to Col2 and Col3 respectively {works better w/o spaces}
Select all the data in C:E and give it the name Database
Select C1
Select the Data Tab and then Advanced in the Sort & Filter group.
Fill in the dialog as shown below.