Copy cells in a determined order

[pmarques]

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 |
+-------------------------------------------------------------------+

 

[flummi]

What I understand is:

You have something like this:

cool hot 1 4
wet 2
dry 3
cool 4
better 5
worse 6

A1="cool"
If "cool" appears in B1:B6 you want "4" in D1 (the line "cool" appears
in).

If that is correct, use this in D1:

=IF(ISNA(VLOOKUP(A1;$B$1:$C$6;2;FALSE));"";VLOOKUP(A1;$B$1:$C$6;2;FALSE))

 

[pmarques]

WHY IN THE EXAMPLE THAT I GIVE (ATTACHED) DOESN'T WORK IN CELL D13
SHOULD GIVE
D13 = DFJ (BECAUSE B9 = 8 AND C9 = DFJ) INSTEAD IS BLANK.
NOTE: I´M WORKING IN EXCEL 97
Thanks for your help





-------------------------------------------------------------------------

 

[pmarques]

Thanks flummi

That's it. For the example that i give (attached) the range should be

=IF(ISNA(VLOOKUP(A2;$B$1:$C$10;2;FALSE));"";VLOOKUP(A2;$B$1:$C$10;2;FALSE))

Thanks a lot