+ Reply to Thread
Results 1 to 7 of 7

In need of a lookup function that meets multiple criteria

  1. #1
    Registered User
    Join Date
    04-16-2013
    Location
    Boston, Massachusetts
    MS-Off Ver
    Excel 2010
    Posts
    50

    In need of a lookup function that meets multiple criteria

    Please see the attached example in excel format for clarification. Note the explanatory comments

    In column A is a list of documents by Document ID. In a separate table each Document ID is repeated in a row every time that an event is logged for that document (Events are identified by Event ID numbers 1-6). For each event that occurs at a given document the 'Event Date' is logged in another column.

    I want all of the Event IDs for a given Document ID to be displayed in one row by the date that they occurred, as pictured in the attached example.

    Any assistance would be greatly appreciated as this is far beyond me level of excel expertise.
    Attached Files Attached Files

  2. #2
    Forum Expert ConneXionLost's Avatar
    Join Date
    03-11-2009
    Location
    Victoria, Canada
    MS-Off Ver
    2010
    Posts
    2,952

    Re: In need of a lookup function that meets multiple criteria

    The column header range B1:G1 should match the Event IDs, i.e. 1, 2, 3, etc.

    Then use:
    Please Login or Register  to view this content.
    Would you like to say thanks? Please click the: " Add Reputation" button, on the grey bar below the post.

  3. #3
    Registered User
    Join Date
    04-16-2013
    Location
    Boston, Massachusetts
    MS-Off Ver
    Excel 2010
    Posts
    50

    Re: In need of a lookup function that meets multiple criteria

    Quote Originally Posted by ConneXionLost View Post
    The column header range B1:G1 should match the Event IDs, i.e. 1, 2, 3, etc.

    Then use:
    Please Login or Register  to view this content.
    Thanks Connexionlost, that formula returned exactly what I was looking for... However, I overlooked the fact that the tables I am working with are in Table format and the formula above doesn't work when my example is formatted as a table. Is there a formula that would work if the data were in two separate tables?

    Thanks again!

  4. #4
    Forum Expert ConneXionLost's Avatar
    Join Date
    03-11-2009
    Location
    Victoria, Canada
    MS-Off Ver
    2010
    Posts
    2,952

    Re: In need of a lookup function that meets multiple criteria

    Can you provide an example of your alternate table format?

  5. #5
    Registered User
    Join Date
    04-16-2013
    Location
    Boston, Massachusetts
    MS-Off Ver
    Excel 2010
    Posts
    50

    Re: In need of a lookup function that meets multiple criteria

    I've attached the same example as before formatted as two tables. These are pulling from a database and need to be configured as tables in order to refresh data. The left table is pulling a list of Documents by ID and the right table is pulling a list of Document events. so they need to be configured as tables in order to refresh data. Does that make sense?
    Attached Files Attached Files

  6. #6
    Forum Expert ConneXionLost's Avatar
    Join Date
    03-11-2009
    Location
    Victoria, Canada
    MS-Off Ver
    2010
    Posts
    2,952

    Re: In need of a lookup function that meets multiple criteria

    I added some Dynamic Named Ranges to facilitate the use of the tables, and modified the formula to compensate for the formatting when no value is returned:
    Attached Files Attached Files

  7. #7
    Registered User
    Join Date
    04-16-2013
    Location
    Boston, Massachusetts
    MS-Off Ver
    Excel 2010
    Posts
    50

    Re: In need of a lookup function that meets multiple criteria

    You most definitely nailed it - this is a huge help. Thanks so much!

+ Reply to Thread

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