Results 1 to 13 of 13

If contains formula with index match formula produces errors

Threaded View

  1. #1
    Registered User
    Join Date
    07-25-2013
    Location
    Atlanta, Georgia
    MS-Off Ver
    Excel 2010
    Posts
    29

    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")
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Index Match Formula doesn't recognize output from Right Formula as lookup value.
    By GoGators in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 07-10-2015, 11:33 AM
  2. Replies: 3
    Last Post: 05-02-2013, 01:31 AM
  3. [SOLVED] Formula whit INDEX and MATCH. I try to make this formula to result.
    By Anka in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-28-2012, 06:26 PM
  4. Nested index formula - need to ignore errors
    By Fursmanm in forum Excel General
    Replies: 0
    Last Post: 09-20-2012, 09:50 AM
  5. Replies: 5
    Last Post: 02-29-2012, 08:51 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1