+ Reply to Thread
Results 1 to 4 of 4

Copy cells in a determined order

  1. #1
    Registered User
    Join Date
    07-11-2005
    Posts
    40

    Copy cells in a determined order

    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
    Attached Files Attached Files

  2. #2
    flummi
    Guest

    Re: Copy cells in a determined order

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


  3. #3
    Registered User
    Join Date
    07-11-2005
    Posts
    40
    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





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

    Quote Originally Posted by 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))

  4. #4
    Registered User
    Join Date
    07-11-2005
    Posts
    40
    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
    Last edited by pmarques; 02-06-2006 at 12:18 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1