Try in W10:

=IFERROR(LOOKUP(2,1/(('RB1'!$E$6:$E$1719=$D10)*(IFERROR(SEARCH("PLT",'RB1'!$J$6:$J$1719),0)+IFERROR(SEARCH("Coop",'RB1'!$J$6:$J$1719),0)+IFERROR(SEARCH("Co-op",'RB1'!$J$6:$J$1719),0)>0)),'RB1'!$BJ$6:$BJ$1719),"")
X10:

=IFERROR(LOOKUP(2,1/(('RB1'!$E$6:$E$1719=$D10)*(IFERROR(SEARCH("PLT",'RB1'!$J$6:$J$1719),0)+IFERROR(SEARCH("VB",'RB1'!$J$6:$J$1719),0)>0)),'RB1'!$BJ$6:$BJ$1719),"")
Both are confirmed by Ctrl-shift-enter.