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")
Bookmarks