Lets say I have an Input Sheet with a list of names and dates. For each
name, there may exist multiple dates (i.e. the names may be listed
multiple times each with a different date).

I established an Output Sheet with all the possible names in the list
(Output column 1). For each unique name (row), I need to pull all
dates associated with that name from the Input Sheet list and fill the
adjacent columns.

I need some sort of VLOOKUP-array thing where all fields matching the
criteria are returned to a range of cells.

When I do it manually, I use the auto-filter and copy and paste from
the filtered list. I need to avoid using macros for this task if at
all possible.

Any ideas?

Thanks in advance!


--
William DeLeo
------------------------------------------------------------------------
William DeLeo's Profile: http://www.excelforum.com/member.php...fo&userid=1256
View this thread: http://www.excelforum.com/showthread...hreadid=382077