Previous Topic Next Topic

Compare two columns and add data from other columns if match fou

Closed
mwilke Posts 3 Registration date Wednesday October 26, 2016 Status Member Last seen March 21, 2017 - Oct 26, 2016 at 03:11 PM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Oct 27, 2016 at 05:39 PM
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?
Related:

3 responses

Answer 1 / 3
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Oct 26, 2016 at 04:03 PM
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
0
Answer 2 / 3
mwilke Posts 3 Registration date Wednesday October 26, 2016 Status Member Last seen March 21, 2017
Oct 27, 2016 at 11:38 AM
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.
0
Answer 3 / 3
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Oct 27, 2016 at 05:39 PM
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.
0

Similar discussions

Comparing columns and returning value
ll -
kittu -

35 responses
Compare values in two columns and return the value from third
ramdubai -
keshav -

11 responses
Extract identical cells of 2 columns (excel)
Little bit lost -
keliza -

3 responses
Comparing Two Excel Sheets and copying like data to third sheet
coz2992 -
TrowaD -

11 responses