Align values of 2 column

Hi
I'm a new user of this forum. I need help to use excel.
I have a worksheet. In this worksheet in the column F i have a list of values (about 47.000). In the column E i have some values (about 3.000) that match with the values of column F. Example:
Column E: 3-7-12-17-56 ecc..
Column F: 1-2-3-5-6-7-9-10-12-13 ecc..
I must allign the values of column E (and the features of values of column E present in the column at the left of column E (D,C,B,A)) with corrispond match in column F, leaving lines blank in column E-D-C-B-A between matchs , like in example:
Column E: ........3..........7............12
Column F: 1-2-3-5-6-7-9-10-12-13
where dots are lines blank
How can i do?
Thanks a lot

Hi,

With your numbers in columns E and F, put this in G1 and auto-fill down the column

=IF(COUNTIF($E$1:$E$100,F1)=0,"",F1) this will put the number from E against the corresponding number in F in column G

Alter the range to suit your range

Hi,

I've had another look at this and need to do some additional work, first of all can you insert a column at A, so all your columns now move over to the right.

Then in A1 type

=F1 and auto-fill down column A (in my example to A9)

Now in H1 put this formula

=IF(COUNTIF($F$1:$F$100,G1)=0,"",G1)

In I1

=IF(H1="","",VLOOKUP(H1,$A$1:$E$100,2))

In J1

=IF(H1="","",VLOOKUP(H1,$A$1:$E$100,3))

In K1

=IF(H1="","",VLOOKUP(H1,$A$1:$E$100,4))

In L1

=IF(H1="","",VLOOKUP(H1,$A$1:$E$100,5))

Then select H1:L1 and auto-fill downwards

See example attached - let me know if it works for you?

I just been reminded you could use this in I1

=IF($H1="","",VLOOKUP($H1,$A$1:$E$100,COLUMN(B1))) drag across to L1 then down

(Thanks VBA Noob)

No problem - thanks for the feedback