How to Find a Matching Pattern and Retrieve Data from the Adjacent Column

I need some help to find and match patterns of strings in a column and fetch data from the adjacent column. I've attached a sample workbook with my sample data.

How can I find the appropriate matching pattern and fetch and fill data from the adjacent column from my source table to destination? I tried the string functions available and used SEARCH function to match the pattern and check whether it is available. However, when the pattern is found, how can I fetch the adjacent column ?

My attempt to code a formula using SUBSTITUTE, MID and SEARCH functions made me stumble at a Frankenstein monster
Below is the monster formula I wrote - it works and returns 1 when the pattern is found.

Formula:

=IF(ISERROR(SEARCH(B2,A2)),IF(OR(IF(ISERROR(SEARCH(MID(B2,1,FIND("(",B2,1)-1)&MID(MID(SUBSTITUTE(SUBSTITUTE(B2,"(","["),")","]"),FIND("[",SUBSTITUTE(SUBSTITUTE(B2,"(","["),")","]"),1),(FIND("]",SUBSTITUTE(SUBSTITUTE(B2,"(","["),")","]"),1)+1-FIND("[",SUBSTITUTE(SUBSTITUTE(B2,"(","["),")","]"),1))),2,1)&MID(B2,FIND(")",B2,1)+1,LEN(B2)),A2)>0),0,SEARCH(MID(B2,1,FIND("(",B2,1)-1)&MID(MID(SUBSTITUTE(SUBSTITUTE(B2,"(","["),")","]"),FIND("[",SUBSTITUTE(SUBSTITUTE(B2,"(","["),")","]"),1),(FIND("]",SUBSTITUTE(SUBSTITUTE(B2,"(","["),")","]"),1)+1-FIND("[",SUBSTITUTE(SUBSTITUTE(B2,"(","["),")","]"),1))),2,1)&MID(B2,FIND(")",B2,1)+1,LEN(B2)),A2)),IF(ISERROR(SEARCH(MID(B2,1,FIND("(",B2,1)-1)&MID(MID(SUBSTITUTE(SUBSTITUTE(B2,"(","["),")","]"),FIND("[",SUBSTITUTE(SUBSTITUTE(B2,"(","["),")","]"),1),(FIND("]",SUBSTITUTE(SUBSTITUTE(B2,"(","["),")","]"),1)+1-FIND("[",SUBSTITUTE(SUBSTITUTE(B2,"(","["),")","]"),1))),4,1)&MID(B2,FIND(")",B2,1)+1,LEN(B2)),A2)>0),0,SEARCH(MID(B2,1,FIND("(",B2,1)-1)&MID(MID(SUBSTITUTE(SUBSTITUTE(B2,"(","["),")","]"),FIND("[",SUBSTITUTE(SUBSTITUTE(B2,"(","["),")","]"),1),(FIND("]",SUBSTITUTE(SUBSTITUTE(B2,"(","["),")","]"),1)+1-FIND("[",SUBSTITUTE(SUBSTITUTE(B2,"(","["),")","]"),1))),4,1)&MID(B2,FIND(")",B2,1)+1,LEN(B2)),A2)))=TRUE,1,0),SEARCH(B2,A2)) 

I need to return the matching pattern that is found. And with it the corresponding adjacent cell's value. Can anyone help me ?