Copy cells in a determined order

P

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

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))
 
P

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





-------------------------------------------------------------------------
 
P

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 :) :)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top