I'm not sure if my subject heading best explains what I'm looking for
but here is my question in greater detail.

I have a chart of data from which I pull from.

A1 = Name1
A2 = Name2
A3 = Name3
A4 = Name4
A5 = Name5

B1 = Date1
B2 = Date1
B3 = Date2
B4 = Date3
B5 = Date2

C1 = (returning value)
C2 = (returning value)
etc.

D1 = (User defined list box)

(by the way, I hate how this google group thing messes up your format
when you post a mock chart on here and screws up the symmetry of it.)

Ok, if the user choose "Date1" in D1, I want Column C to list all the
names with the corresonding date. My obstacle is that Excel seems to
only see the 1st or 2nd date and returns that name only, repeats that
same name. I'm trying to find a way to list them all. I could be
totally off, but I was thinking there was a way to say that if one
value was already listed in column C it would search the next value
and so forth until all names have been found with the corresponding
dates in Column B.

I realize I may not even have the best approach or asking too much of
Excel, so I welcome an suggestions and/or criticisms.