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

1. ## 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. ## 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>

3. ## 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,"")

4. ## 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. ## 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. ## 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!

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

#### Posting Permissions

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