If contains formula with index match formula produces errors

Thanks in advance for your time and help!
Dear Excel Gurus'

I have a master list of inventory items (ITEM MASTER EXTRACT) that comprises of item numbers and item descriptions. I also have a 2nd list of items (PURCH_HIST_ALBLIVSAL_EXP_072213) that i only have item descriptions for. I am trying to create a formula that will take the item description from the 2nd list of items and search all of the item descriptions in the 1st list and if it contains any of the same description, then return the corresponding item number. I have created the formula below. I also have attached a sample. Please help me figure out what I am missing?? I keep getting only "NOT FOUND".

=IFERROR(CONTAINS(I90&"*",ITEM_MASTER_EXTRACT_072213!B:B,1)*INDEX(ITEM_MASTER_EXTRACT_072213!A:A,MATCH(PURCH_HIST_ALBLIVSAL_EXP_072213!A:A&"*",ITEM_MASTER_EXTRACT_072213!B:B,0),ITEM_MASTER_EXTRACT_072213!A92),"NOT FOUND")

I have attached a more detailed file. My actual file is very large and I have had to take a smaller sample. Hopefully this will make more sense. You will see that I have tried 3 different formulas in the 1st tab, column labeled "Item".

thanks in advance!

Nicole Matthews sample 2.xls above

thanks!!

Oh okay, thanks for clarifying. Apology that I was not specific.
For example, on the 1st tab - "Purch_Hist..etc" Row 92, Col.B should yield one of the following results from the 2nd tab- "Item Master Extract..." row 1893, row 1894 or row 1910 in Column B.

Essentially what I am trying to do is see if these items from 1st tab already exist anywhere in our master inventory so I will not have to recreate it.

thank you so much! I will review this to see what i missed and hopefully follow-up with you tomorrow on my other options for the rest!! Get some rest!! Humbly, I thank you!!!

Thanks so much! Yeah, I know the there was alot of inconsistencies in the data, which I knew would be hard to find; however I knew the right combination of formulas would yield a majority if they have any close matches. Sample 4 and Sample 5 in some instances pulled different information, so I will compare those two and take all values in Sample 5 that returned and use those values if Sample 4 did not return a value for the same item in the Item field.

Hey martindwilson ...also Formula Guru...

I was going though the file and I just caught something. Looking at sample 4, why isn't line 227 on "PURCH_HIST_ALBLIVSAL_EXP_072213" not returning line 1649 or 1650 on "ITEM_MASTER_EXTRACT_072213"?

If I understand the formula correctly, it is taking the left 8 characters from the lookup value and returning matches from "ITEM_MASTER_EXTRACT_072213"???