+ Reply to Thread
Results 1 to 1 of 1

New & Lost: Multi Criteria & Multi Row INDEX, SMALL, MATCH...

  1. #1
    Registered User
    Join Date
    05-23-2014
    Posts
    1

    New & Lost: Multi Criteria & Multi Row INDEX, SMALL, MATCH...

    Hello, I've been a long time learner form this forum but decided to join in the conversation. I've been fighting with this workbook for days now and have it somewhat close on a few parts. Here's my details.

    My Goal:
    • reference main data sheet
    • create list based on drop down selection
    • check multiple rows in data sheet
    • use index and match with multiple criteria from multiple columns
    • I'd like to be able to use as many items or as few if possible

    I've been having trouble because each user can have many "items" and our data is receive in this format. I've tried to work from similar examples but can't seem to get the multiple to work. I've attached a worksheet for example. In this sheet my formula broke for "1. item1 Only" when preparing to share but I do have a single item working with the formula in A1 of "1. item1 Only". If I'm leaving out helpful details please let me know.

    Thanks in advance!

    Morley
    Attached Files Attached Files
    Last edited by morleyp; 05-23-2014 at 12:45 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 6
    Last Post: 04-30-2014, 02:42 AM
  2. Index with imbedded multi-criteria Match
    By DFELS in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-29-2013, 06:46 AM
  3. Count it multi criteria accross multi cells
    By jfoley5197 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-10-2013, 03:42 PM
  4. SOS:Return multiple values against multi criteria match and index function
    By nitesh_inin in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 11-26-2012, 05:45 PM
  5. Multi Criteria Index and Match - Getting #NA Error
    By abbati77 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-07-2012, 03:22 AM

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