Compare two columns with another two columns and return
Closed
Ree1931
-
Oct 30, 2015 at 12:41 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Nov 2, 2015 at 11:02 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Nov 2, 2015 at 11:02 AM
Related:
- Compare two columns with another two columns and return
- Display two columns in data validation list but return only one - Guide
- Flipkart return comments - Guide
- Compare two worksheets and paste differences to another sheet - excel vba free download - Excel Forum
- Beyond compare - Download - File management
- Macro to compare 2 sheets and copy differences ✓ - Excel Forum
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
Nov 2, 2015 at 11:02 AM
Nov 2, 2015 at 11:02 AM
Hi Ree1931,
I put you sample data in the range A1:C4.
Then I used range F2:H2 for Zip code, City and formula:
=SUM((A2:A4=F2)*(B2:B4=G2)*(C2:C4))
This is an array formula and needs to be confirmed by hitting Ctrl+Shift+Enter instead of just Enter.
Best regards,
Trowa
Monday, Tuesday and Thursday are usually the days I'll respond. Bear this in mind when awaiting a reply.
I put you sample data in the range A1:C4.
Then I used range F2:H2 for Zip code, City and formula:
=SUM((A2:A4=F2)*(B2:B4=G2)*(C2:C4))
This is an array formula and needs to be confirmed by hitting Ctrl+Shift+Enter instead of just Enter.
Best regards,
Trowa
Monday, Tuesday and Thursday are usually the days I'll respond. Bear this in mind when awaiting a reply.