Thank you for complying with the moderators request to list cross posts. I assume that since you have not posted a solution, as you stated you would when you got one, that none have been proposed.
This solution uses two formulas. The following array entered formula* retrieves the DESC:
Formula:
=INDEX(master!B$2:B$14,SMALL(IF(master!C$2:C$14=H$1,ROW(A$1:A$13)),ROW(A1)))
The following formula will retrieve the numeric values:
Formula:
=SUMPRODUCT((master!$B$2:$B$14=$B9)*(master!$C$2:$C$14=$H$1)*(master!D$2:D$14))
*Array entered formulae are activated by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.
To see the formulae applied look at the 'for 312' sheet, yellow shaded section.
Let me know if you have any questions.
Bookmarks