Searching two columns and displaying a third
Closed
ahmetcandan
-
Jul 14, 2018 at 03:50 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Jul 16, 2018 at 12:18 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Jul 16, 2018 at 12:18 PM
Related:
- Searching two columns and displaying a third
- Display two columns in data validation list but return only one - Guide
- How to search for a word on a page - Guide
- Safe searching setting - Guide
- Tweetdeck larger columns - Guide
- How to search within a youtube channel - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Updated on Jul 19, 2018 at 11:26 AM
Updated on Jul 19, 2018 at 11:26 AM
Hi ahmetcandan,
I've got a solution for you, although it might not be the best:
Reserve 2 extra columns.
Column G:
Enter '1' in G1 and drag it down.
Column H:
Enter formula in H1:
=SUM(($A$1:$A$8=$F$1)*($B$1:$B$8=D1)*($G$1:$G$8))
Confirm this formula by hitting Ctrl+Shift+Enter as this is an array formula.
Drag the formula down ( make sure the number of rows are correct ).
And finally the formula in column E:
=INDIRECT("C"&H1)
Drag the formula down.
Kind of a workaround. Keep in mind that column G and H can be placed out of sight, be hidden , text be made white or placed on a different sheet. To keep the same look.
Best regards,
Trowa
I've got a solution for you, although it might not be the best:
Reserve 2 extra columns.
Column G:
Enter '1' in G1 and drag it down.
Column H:
Enter formula in H1:
=SUM(($A$1:$A$8=$F$1)*($B$1:$B$8=D1)*($G$1:$G$8))
Confirm this formula by hitting Ctrl+Shift+Enter as this is an array formula.
Drag the formula down ( make sure the number of rows are correct ).
And finally the formula in column E:
=INDIRECT("C"&H1)
Drag the formula down.
Kind of a workaround. Keep in mind that column G and H can be placed out of sight, be hidden , text be made white or placed on a different sheet. To keep the same look.
Best regards,
Trowa