Ask Your Question
0

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 2015-10-26 22:12:57 +0200

Alex Kemp gravatar image

Hi,

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
2

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

Gabriel gravatar image
edit flag offensive delete link more

Question Tools

Stats

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

Seen: 22,579 times

Last updated: Jul 24 '12