I need a formula (or some other type of solution)
That Copys ocurrences from columm C to D when the number in A apears
(one or more times) in B.
The data copyed (from C to D) should be in the same line that the
number apears in A.
The example is more clear :) (the columm D is the result that i wont)

Note:I have tried something like (columm E)
=IF(COUNTIF($A$2:$A$13;B8)=1;C8;"")
but doesn't works, it gives the records that i wont but not in the
correct cells...

Thanks in advanced


+-------------------------------------------------------------------+
|Filename: Example 3.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4324 |
+-------------------------------------------------------------------+

--
pmarques
------------------------------------------------------------------------
pmarques's Profile: http://www.excelforum.com/member.php...o&userid=25110
View this thread: http://www.excelforum.com/showthread...hreadid=508890