Vlookup multiple values to be shown

[Zueri]

Hi guys

I need to create a project plan where we see on a calendar which projects are on which date. I managed to do this with Vlookup on my own, but the problem is that it only shows the first project on that date.

I need it to show all projects that are on that date, not only the first one. Attached you find a very simple version of my project plan, maybe someone can help me? As you can see on 01.01.2019 it only shows Project 1, but it should show Project 1 and Project 3 as they are both on the same date.

Would really appreciate some help on this!

Best regards

Zueri

[Pepe Le Mokko]

One of many answers https://fiveminutelessons.com/learn-...le-values-list

[Zueri]

Yeah I saw that but my excel skills are unfortunately not so good. I have not figured out how to use it with the table that I have

[Olly]

A left field approach:

Use Power Query to transform your source data:

EventList:

Please Login or Register  to view this content.

Close and load to Data Model.

Add a Measure to the data model:

Please Login or Register  to view this content.

Now in your "Calendar", you can use this formula (and format cells to wrap text):

Please Login or Register  to view this content.

Use Data > Refresh All to update values after changes made to source data.