Results 1 to 7 of 7
  1. #1
    3 Star Lounger
    Join Date
    Mar 2004
    Location
    North Carolina, USA
    Posts
    268
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Match Found cut and paste from one column to anoth (2000)

    I have two lists on the same spreadsheet with historical timekeeper data and new timekeeper data. I'd like to, when a match between lists is encountered, copy a timekeeper number from the new list into a blank column adjacent to the old timekeeper data. I know how to find the identify the matches and assign true when a match is encountered.

    Part I need help with is when a true is encountered, I'd like to copy the timekeeper number from the old list and paste it into the corresponding row on the old list. See attached spreadsheet.

    All help is appreciated.

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Match Found cut and paste from one column to anoth (2000)

    Is this what you are looking for:

    <pre>=IF(O2=H2,C2,"")
    </pre>

    Legare Coleman

  3. #3
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Match Found cut and paste from one column to anoth (2000)

    If I understand your question correctly this formula will work!!!
    Type it into the "D" column: =IF(P2,T2,"")
    Regards,
    Rudi

  4. #4
    3 Star Lounger
    Join Date
    Mar 2004
    Location
    North Carolina, USA
    Posts
    268
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Match Found cut and paste from one column to anoth (2000)

    Rudi, this appears to work. Can you explain this formula to me?

    Thanks.

  5. #5
    3 Star Lounger
    Join Date
    Mar 2004
    Location
    North Carolina, USA
    Posts
    268
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Match Found cut and paste from one column to anoth (2000)

    Legare, I tried with no success. In what cell should I be placing this formula?

    Thanks.

  6. #6
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Match Found cut and paste from one column to anoth (2000)

    Nice to know!
    The IF function consists of 3 parts; 1. A logical Test, 2. The true part and 3 The false part!
    The Logical test must evaluate to true or false. P2 already has true or false, so =If(P2 evaluates to true if the cell is true and false if the cell is false.
    If the evaluation is true, it completes the true part as in 2 above. In the formula this is T2 which is the value of cell T2, else it returns nothing ( "").

    =If(P2 equals TRUE, then show the value in T2, else show nothing ( "" ).

    Hope this is clear enough!
    Regards,
    Rudi

  7. #7
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Match Found cut and paste from one column to anoth (2000)

    It goes in the cell where you want the ID number if cell O2 is equal to H2. It can be copied down to other cells in the column to work on other rows.
    Legare Coleman

Posting Permissions

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