software

I need a formula (or some other tipe 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 (in D) should be in the same line that the number
apears in B.
The example (attached) should Help
I have tried something like
=IF(COUNTIF($A$2:$A$10;B2) gt;=1;C2;quot;quot;) but doesn't works
Thanks in advanced -------------------------------------------------------------------
|Filename: Example 2.zip |
|Download: www.excelforum.com/attachment.php?postid=4313 |
-------------------------------------------------------------------

--
pmarques
------------------------------------------------------------------------
pmarques's Profile: www.excelforum.com/member.php...oamp;userid=25110
View this thread: www.excelforum.com/showthread...hreadid=508215Put this in D1 and copy down...........

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

Vaya con Dios,
Chuck, CABGx3
quot;pmarquesquot; wrote:

gt;
gt; I need a formula (or some other tipe of solution)
gt; That Copys ocurrences from columm C to D when the number in A apears
gt; (one or more times) in B.
gt; The data copyed (in D) should be in the same line that the number
gt; apears in B.
gt; The example (attached) should Help
gt; I have tried something like
gt; =IF(COUNTIF($A$2:$A$10;B2) gt;=1;C2;quot;quot;) but doesn't works
gt; Thanks in advanced
gt;
gt;
gt; -------------------------------------------------------------------
gt; |Filename: Example 2.zip |
gt; |Download: www.excelforum.com/attachment.php?postid=4313 |
gt; -------------------------------------------------------------------
gt;
gt; --
gt; pmarques
gt; ------------------------------------------------------------------------
gt; pmarques's Profile: www.excelforum.com/member.php...oamp;userid=25110
gt; View this thread: www.excelforum.com/showthread...hreadid=508215
gt;
gt;


*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.*--------------------------------------------------------------------------

CLR Wrote:
gt; Put this in D1 and copy down...........
gt;
gt; =IF(ISNA(VLOOKUP(A1,B:B,1,FALSE)),quot;quot;,IF(VLOOKUP(A1 ,B:B,1,FALSE)=A1,C1,quot;quot;))
gt;
gt; Vaya con Dios,
gt; Chuck, CABGx3
gt;
gt;
gt;
gt; quot;pmarquesquot; wrote:
gt;
gt; gt;
gt; gt; I need a formula (or some other tipe of solution)
gt; gt; That Copys ocurrences from columm C to D when the number in A apears
gt; gt; (one or more times) in B.
gt; gt; The data copyed (in D) should be in the same line that the number
gt; gt; apears in B.
gt; gt; The example (attached) should Help
gt; gt; I have tried something like
gt; gt; =IF(COUNTIF($A$2:$A$10;B2) gt;=1;C2;quot;quot;) but doesn't works
gt; gt; Thanks in advanced
gt; gt;
gt; gt;
gt; gt;
gt; -------------------------------------------------------------------
gt; gt; |Filename: Example 2.zip
gt; |
gt; gt; |Download: www.excelforum.com/attachment.php?postid=4313
gt; |
gt; gt;
gt; -------------------------------------------------------------------
gt; gt;
gt; gt; --
gt; gt; pmarques
gt; gt;
gt; ------------------------------------------------------------------------
gt; gt; pmarques's Profile:
gt; www.excelforum.com/member.php...oamp;userid=25110
gt; gt; View this thread:
gt; www.excelforum.com/showthread...hreadid=508215
gt; gt;
gt; gt;--
pmarques
------------------------------------------------------------------------
pmarques's Profile: www.excelforum.com/member.php...oamp;userid=25110
View this thread: www.excelforum.com/showthread...hreadid=508215
More ideas please. Thanks--
pmarques
------------------------------------------------------------------------
pmarques's Profile: www.excelforum.com/member.php...oamp;userid=25110
View this thread: www.excelforum.com/showthread...hreadid=508215I'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, CABGx3quot;pmarquesquot; gt; wrote in
message news
gt;
gt; *Didn't work for me... D12 = 0 and D13 = 0 should give D12 = dfh and D13
gt; = dfj
gt; I'm working in excel 97...
gt; Thanks the
gt;
same.*----------------------------------------------------------------------
----
gt;
gt; CLR Wrote:
gt; gt; Put this in D1 and copy down...........
gt; gt;
gt; gt;
=IF(ISNA(VLOOKUP(A1,B:B,1,FALSE)),quot;quot;,IF(VLOOKUP(A1 ,B:B,1,FALSE)=A1,C1,quot;quot;))
gt; gt;
gt; gt; Vaya con Dios,
gt; gt; Chuck, CABGx3
gt; gt;
gt; gt;
gt; gt;
gt; gt; quot;pmarquesquot; wrote:
gt; gt;
gt; gt; gt;
gt; gt; gt; I need a formula (or some other tipe of solution)
gt; gt; gt; That Copys ocurrences from columm C to D when the number in A apears
gt; gt; gt; (one or more times) in B.
gt; gt; gt; The data copyed (in D) should be in the same line that the number
gt; gt; gt; apears in B.
gt; gt; gt; The example (attached) should Help
gt; gt; gt; I have tried something like
gt; gt; gt; =IF(COUNTIF($A$2:$A$10;B2) gt;=1;C2;quot;quot;) but doesn't works
gt; gt; gt; Thanks in advanced
gt; gt; gt;
gt; gt; gt;
gt; gt; gt;
gt; gt; -------------------------------------------------------------------
gt; gt; gt; |Filename: Example 2.zip
gt; gt; |
gt; gt; gt; |Download: www.excelforum.com/attachment.php?postid=4313
gt; gt; |
gt; gt; gt;
gt; gt; -------------------------------------------------------------------
gt; gt; gt;
gt; gt; gt; --
gt; gt; gt; pmarques
gt; gt; gt;
gt; gt; ------------------------------------------------------------------------
gt; gt; gt; pmarques's Profile:
gt; gt; www.excelforum.com/member.php...oamp;userid=25110
gt; gt; gt; View this thread:
gt; gt; www.excelforum.com/showthread...hreadid=508215
gt; gt; gt;
gt; gt; gt;
gt;
gt;
gt; --
gt; pmarques
gt; ------------------------------------------------------------------------
gt; pmarques's Profile:
www.excelforum.com/member.php...oamp;userid=25110
gt; View this thread: www.excelforum.com/showthread...hreadid=508215
gt;