Matching Extracted Number with an Array of Extracted Numbers

Hi All,

I have attached a small sample spreadsheet.

Not sure if my subject header is a clear description of what I want to solve, but nonetheless here goes:

In Sheet1, for each row, I would like to extract the 5 digit number (which is between brackets) from the description in Column B. Then compare it against an array of similarly extracted 5 digit numbers from Column B in Sheet2.

Then, if there is a match, place the number in column I of Sheet1 into column K in Sheet1

I need to have a formula in each row of Column K in Sheet1 which does all of the above and not have separate columns for the extraction process as I have in the sample spreadsheet.

Hope this description is clearer than mud!!

Any help would be appreciated.

How does the data set make sense?
The description and extraced code in Sheet1 are all duplicates.

Not sure if this what you had in mind, since you're on Office 365, this should work:
=ISNUMBER(MATCH(MID(B3:B8,SEARCH("(?????)",B3:B8)+1,5),MID(Sheet2!B4:B30,SEARCH("(?????)",Sheet2!B4:B30)+1,5),))*I3:I8

Thanks to Both AliGW and RaulSerg.