Ok, revised for the new information presented.

Assumptions - your data is laid out in A, B, C and D as you indicated and
starts in row 1 and continues to row 100.
To get the matching names, use this in E1 and drag down:
=IF(ISNA(MATCH(A1,C$1:C$100,0)),"",INDEX(C$1:C$100 ,MATCH(A1,C$1:C$100,0),0))
then in at F1 to get the value associated with the matched names, use this
and drag down:
=IF(ISNA(MATCH(A1,C$1:C$100,0)),"",INDEX(D$1:D$100 ,MATCH(A1,C$1:C$100,0),0))

"fak119" wrote:

That was great, thank you! However the problem is not yet completely solved...

Next to each text (name) are values, but they are different! This value
should go next to the name, and the final four columns would look like this:

Miller 25 Miller 40
Smith 35 (will later be ignored)
Kerry 21 Kerry 119
Ferguson 12 Ferguson 15
Peters 100 (will later be ignored)
Black 13 Black 13 (same value is possible and ok)

etc.


"Ardus Petus" wrote:

Say 1st column is column A, 2nd column is column B.
Enter in C1:
=IF(ISNA(VLOOKUP(A1,B:B,1,0)),"",VLOOKUP(A1,B:B,1, 0))
and drag down

HTH
--
AP

"fak119" a écrit dans le message de news:
...
I have to columns, alphabetically sorted, one with 1oo names, one with
8o-9o
names, which are identical to the ones in the column with 1oo.

Is there a way (formula or macro) that places the identical text (names)
next to each other in the same row, leaving blank the cell where there is
no
match?

The columns should then look like this:

Miller Miller
Smith
Kerry Kerry
Ferguson Ferguson
Peters
Black Black

etc.


Thank you