+ Reply to Thread
Results 1 to 4 of 4

Listing ALL entries of index/match (not just first entry)

  1. #1
    Registered User
    Join Date
    03-28-2016
    Location
    Canada
    MS-Off Ver
    2010
    Posts
    36

    Listing ALL entries of index/match (not just first entry)

    Hi,

    I have a sheet which serves as the master database for our orders. I am trying to make another sheet within the same workbook which will list any entries matching a specific value (i.e. "To Order"). I also need to list the start/end dates to the right of the entry.

    Master Database
    A: Item (lists articles of clothing
    B: Status (Purchased, To Order, etc)
    C: Start Date (date of which the action has been entered into database)
    D: End Date (date of which the order is completed)

    Filtered List
    I want this to list everything with a status of "To Order", including the item, start & end dates.

    I've come up with this formula, but it's not quite working properly: =IF(ISERROR(INDEX(data!$A$1:$D$7,SMALL(IF(data!$B$1:$B$7=$B$1,ROW(data!$B$1:$B$7)),ROW(1:1)),1)),"",INDEX(data!$A$1:DB$7,SMALL(IF(data!$B$1:$B$7=$B$1,ROW(data!$B$1:$B$7)),ROW(1:1)),1))

    Sample file is attached. Any help would be greatly appreciated!

    Cheers!
    Attached Files Attached Files

  2. #2
    Forum Expert shukla.ankur281190's Avatar
    Join Date
    05-17-2014
    Location
    Lucknow, India
    MS-Off Ver
    Office 365
    Posts
    3,935

    Re: Listing ALL entries of index/match (not just first entry)

    Try in sheet Filtered List

    Change the cell value as below.

    A1=To Order
    B1=Item

    The Try

    B2
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    ...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.

    Check the attached file.
    Attached Files Attached Files
    If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)

  3. #3
    Registered User
    Join Date
    03-28-2016
    Location
    Canada
    MS-Off Ver
    2010
    Posts
    36

    Re: Listing ALL entries of index/match (not just first entry)

    Great, thank you SO much for the help!!

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,719

    Re: Listing ALL entries of index/match (not just first entry)

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

+ 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. Index/Match to Match entries on multiple criteria
    By manning457 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-06-2015, 02:32 PM
  2. Sum Multiple Entries Through Index and Match
    By jmcconville18 in forum Excel General
    Replies: 2
    Last Post: 11-20-2014, 10:39 AM
  3. [SOLVED] Index and Match duplicate entries
    By pauldaddyadams in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-04-2013, 07:04 AM
  4. Replies: 14
    Last Post: 11-30-2012, 02:54 PM
  5. Index/match with Data Validation Listing
    By rise206 in forum Excel General
    Replies: 7
    Last Post: 12-30-2010, 12:36 PM
  6. Match/Index with multiple entries
    By Jsaper in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-25-2010, 04:34 AM
  7. index match with blank entries
    By andrewm in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 09-06-2005, 12:05 PM

Tags for this Thread

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