Results 1 to 5 of 5

Multiple Matches - Index/Match

Threaded View

  1. #1
    Registered User
    Join Date
    07-24-2007
    Posts
    4

    Multiple Matches - Index/Match

    hello -

    I have attached a simplified workbook which contains my problem.

    Worksheet "BI" contains the data.
    Worksheet "Main" displays data based on the given date (A3).

    When "Main" is active, I would like the user to be able to enter a date into (A3) and have all corresponding 'Widgets' displayed in (A4) and all corresponding 'Units' to be displayed in (B4). If a second 'Unit' matches the given criteria (date) i would like that to be displayed in (A5) and (B5) respectively.

    I am able to do this when only one 'Unit' matches the given criteria.
    =INDEX(BI!A2:BI!A21,MATCH(A3,BI!B2:BI!B21,0))

    Notice how Ship Date (BI!B10, and BI!B11) are the same, 7/25/2007. If I were to type in 7/25 to (Main!A3) I would like to see both 'Widgets' displayed along with their respective 'Units'.

    May 24, 2007
    BI0009 | 5
    BI0010 | 5

    Hope this makes sense, apologies if this has been answered before--i've searched but i can't find anything.

    brdwlsh
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

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