formula to copy ocurrences...

[pmarques]

I need a formula (or some other tipe of solution)
That Copys ocurrences from columm C to D when the number in A apear
(one or more times) in B.
The data copyed (in D) should be in the same line that the numbe
apears in B.
The example (attached) should Help
I have tried something like
=IF(COUNTIF($A$2:$A$10;B2) >=1;C2;"") but doesn't works
Thanks in advanced :

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

 

[CLR]

Put this in D1 and copy down...........

=IF(ISNA(VLOOKUP(A1,B:B,1,FALSE)),"",IF(VLOOKUP(A1,B:B,1,FALSE)=A1,C1,""))

Vaya con Dios,
Chuck, CABGx3

 

[pmarques]

*Didn't work for me... D12 = 0 and D13 = 0 should give D12 = dfh and D13
= dfj
I'm working in excel 97...
Thanks the
same.*--------------------------------------------------------------------------

 

[pmarques]

More ideas please. Thanks

 

[CLR]

I'm sorry....evidently I mis-understood what you are looking for. Perhaps
you could elaborate, giving specific cell numbers with values and what
results exactly are expected in some simple model.....then maybe we can help
more.....

Vaya con Dios,
Chuck, CABGx3