Results 1 to 5 of 5

Returning several values from a column if they're a match

Threaded View

  1. #1
    Registered User
    Join Date
    08-04-2011
    Location
    Bordeaux, France
    MS-Off Ver
    Excel 2007
    Posts
    5

    Returning several values from a column if they're a match

    Hey guys,

    Here is the thing:
    I've got this table where I have 2 columns. One that contains TEXT (name of the task that needs to be done), one that contains DATE (due date of the task).

    I'd like to be able to see "what tasks need to be done" by typing in a specific cell their due date.
    Just to help you understand, let's name "Task one" T1, "task two" T2, etc.

    T1, T2, T5 and T6 are due on 01/01/2012
    T3 and T4 are due on 02/02/2012

    If, in my cell I type "01/01/2012" then it will return me the list of the tasks that have to be done on THIS specific day like that :
    T1
    T2
    T5
    T6
    (I don't care much in which order, I just want it to be a list. Each task in a separate cell)

    I've tried using the "lookup" function and telling the function to look for the value I enter in my cell in DATE and then return me the value from the same line in the TEXT column, but I'm stuck. The lookup function returns only ONE value (since it's in ONE cell), if I type the same function all the way, it always return the same value. Basically, I'm currently stuck if I have several possible values.

    I'd either need to be able to tell my lookup function "Hey buddy, don't return me the same result twice. If this one is already listed above, then find the next one" or I need to just find another way around.

    Any thoughts on this ?
    Thanks in advance, and I hope I was clear enough in my explanation!
    Last edited by Ranu; 09-22-2011 at 07:54 AM.

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