vlookup & concatenate?

[JamiT]

I am trying to do a vlookup (or should I use another function???) of several rows of dates and events, then pull all the events that occur on the same date into a single cell (in a calendar)? For example:

Here is the list of events by date

10/29/2008 All-Team Meeting
11/19/2008 All-Team Meeting
8/27/2008 All-Team Meeting
8/27/2008 Test

I want my calendar for August to show all the events that occur on each particular day (in my formula below, you’ll notice that I am only able to pull the first value for the 8/27/08 entry).

Here is my [incorrect] formula:
=IF(ISERROR(VLOOKUP(J15,'Comm. Plan'!$A:$B,2,FALSE)),"",(VLOOKUP(J15,'Comm. Plan'!$A:$B,2,FALSE)))

Here is what I would like to see for August 28th:


25-Aug
26-Aug
27-Aug
28-Aug All-Team Meeting, Test

Lastly, I would like the rows to auto-size based on all the entries that fill up each date.


Thank you in advance - this is a problem that has plagued me for a year now!

 

[MrKowz]

What you could do is set an advanced filter that has its criteria based on the entry of another cell.

 

[JamiT]

Can you explain a little further?

I have about 300 rows of data that I want to populate into my 2008-2009 calendar, month by month.

 

[andrewman]

Can email your file to me? I will add my code in it.