We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

IF [find value in a column] THEN [copy value from a different column] [closed]

asked 2012-07-24 17:33:29 +0200

Gabriel gravatar image

updated 2021-06-15 16:35:07 +0200

Alex Kemp gravatar image


I have a spreadsheet with 10 columns. Column 1 has ID's, the rest (2 trough 10) have data attached to that ID's. Now I have a new column (column 11) where only some of the IDs in column 1 are present and not in order.

I want to attach in column 12 data present in column 2 and I need a way to search column 1 until the correct ID (ie: matching the ID in column 11) is found and when this happens, paste the data present in column 2.

Please tell me if I'm not being clear.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-10-17 03:32:50.578666

1 Answer

Sort by » oldest newest most voted

answered 2012-07-24 19:31:18 +0200

Gabriel gravatar image
edit flag offensive delete link more

Question Tools


Asked: 2012-07-24 17:33:29 +0200

Seen: 28,295 times

Last updated: Jul 24 '12