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
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Oct 27, 2016 at 05:39 PM
Related:
- Compare two columns and add data from other columns if match fou
- Display two columns in data validation list but return only one - Guide
- Pdf and xps add in 2007 - Download - Other
- Tweetdeck larger columns - Guide
- How to add @ in laptop - Guide
- Beyond compare - Download - File management
3 responses
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Oct 26, 2016 at 04:03 PM
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
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
mwilke
Posts
3
Registration date
Wednesday October 26, 2016
Status
Member
Last seen
March 21, 2017
Oct 27, 2016 at 11:38 AM
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.
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Oct 27, 2016 at 05:39 PM
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.
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.
