How to find Multiple lookup value with same lookup criteria

[Ariful Islam]

I am using this =INDEX($C$2:$C$12,MATCH($A2&$B2,INDEX($A$2:$A$12&$B$2:$B$12,0),0)) formula to find lookup value where lookup criteria are A2 and B2.
There are many lookup values against lookup criteria A2 and B2, simply i want to find them using non-volatile formula.

 

[Aladin Akyurek]

Control+shift+enter, not just enter, and copy down:

=IFERROR(INDEX($C$2:$C$12,SMALL(IF($A$2:$A$12&"|"&$B$2:$B$12=$A2&"|"&$B2,ROW($C$2:$C$12)-ROW($C$2)+1),ROWS($1:1))),"")