Hey guys! Need help...I'm close but my formula still need some tweaking.
I am trying to take some data (item description - comprises of numbers and text) from a column in one worksheet and look against another item description column in another worksheet and return corresponding item number.
Here is the formulas I've come up with below:
IFERROR(SEARCH("I92",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!A:A&"*"),"NOT FOUND")
=IFERROR(CONTAINS(I92&"*",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 sample file for further review...
Bookmarks