Closing this matter due to rewriting request.
Closing this matter due to rewriting request.
Last edited by Excel Sloth; 12-06-2020 at 06:17 PM. Reason: Premature Closing; Starting Over
Are some of your expected answers incorrect??
D21, copied across and dnown:
=IFERROR(INDEX(E$3:E$15,MATCH(1,(($A$3:$A$15=$A21)*($C$3:$C$15=$B21)*($D$3:$D$15=$C21)*($B$3:$B$15=$D$19)),0)),"")
H21, copied across and down:
=IFERROR(INDEX(E$3:E$15,MATCH(1,(($A$3:$A$15=$A21)*($C$3:$C$15=$B21)*($D$3:$D$15=$C21)*($B$3:$B$15=$H$19)),0)),"")
If your REALLY want aload of zeros in the empty cells, replace "" with 0
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
Glenn, Many thanks! This might sound a bit strange, but I can't wait to get to the office on Monday AM to apply these formulas to my larger work product. I appreciate you sir!
Mmm. That's a bit sad!! But, maybe not as sad as me spending part of a Sunday afternoon on the Excel forum!!
You're welcome.
If that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.
It'd also be appreciated if you were to click the Add Reputation button at the foot of any of the posts of all members who helped you reach a solution.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks