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 January 16, 2023 - Nov 2, 2015 at 11:02 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - 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
- Compare two worksheets and paste differences to another sheet - excel vba free download ✓ - Excel Forum
- Macro to compare two excel sheets ✓ - Excel Forum
- If cell contains (multiple text criteria) then return (corresponding text criteria) ✓ - Excel Forum
- Excel compare two columns for partial matches - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 16, 2023
549
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.