Compare two columns and add data from other columns if match fou [Closed]

Report
Posts
3
Registration date
Wednesday October 26, 2016
Status
Member
Last seen
March 21, 2017
-
Posts
1852
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
November 7, 2020
-
Ok i have names in Columns D and Columns I. I want to compare those two and if they match i want to copy the data adjacent to column I (J and K) to the cells adjacent to column D (E and F).

I cant for the life of me figure this out. Any help?

3 replies

Posts
1852
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
November 7, 2020
136
mwilke, Good evening.

Try to use:

E1 --> =IF(D1=I1, J1, "")

F1 --> =IF(D1=I1, K1, "")

Copy it down.

Is that what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Posts
3
Registration date
Wednesday October 26, 2016
Status
Member
Last seen
March 21, 2017

The names in the two columns are not "matched up" as in D1 will not match I1. The D1 column has multiple values of the same name in I1. So that wont work.
Posts
1852
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
November 7, 2020
136
mwilke, Good evening.

Please, explain your neccesity in a better way.

Give us a real example about your data or save your example file at a free site as www.sendspace.com and put a link here to download.

This will easier the solution.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!