Multiple Condition Lookup Array

[Finalfight40]

Hi All

I have a spreadsheet which looks like below:

Sheet1:

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[/TR]
[TR]
[TD]PROJECT[/TD]
[TD]START DATE 1[/TD]
[TD]END DATE 1[/TD]
[TD]START DATE 2[/TD]
[TD]END DATE 2[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]07/01/2018[/TD]
[TD]06/04/2018[/TD]
[TD]01/06/2018[/TD]
[TD]01/09/2018[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]04/04/2018[/TD]
[TD]05/07/2018[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD]04/04/2018[/TD]
[TD]07/07/2018[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]D[/TD]
[TD]10/10/2018[/TD]
[TD]02/02/2019[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]E[/TD]
[TD]01/01/2018[/TD]
[TD]02/03/2018[/TD]
[TD]05/06/2018[/TD]
[TD]03/08/2018[/TD]
[/TR]
[TR]
[TD]F[/TD]
[TD]17/03/2018[/TD]
[TD]18/04/2018[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

What i am looking for on sheet 2 is a list of the projects like below:

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Jan 18[/TD]
[TD]Feb 18[/TD]
[TD]Mar 18[/TD]
[TD]Apr 18[/TD]
[TD]May 18[/TD]
[TD]June 18[/TD]
[TD]July 18[/TD]
[TD]Aug 18[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]A[/TD]
[TD]A[/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]B[/TD]
[TD]B[/TD]
[TD]A[/TD]
[/TR]
[TR]
[TD]E[/TD]
[TD]E[/TD]
[TD]E[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]C[/TD]
[TD]C[/TD]
[TD]E[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]F[/TD]
[TD]C[/TD]
[TD][/TD]
[TD]A[/TD]
[TD]A[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]F[/TD]
[TD][/TD]
[TD]E[/TD]
[TD]E[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


I am using the formula to pull through the first date to the second sheet and then adding a month every time.

=DATE(YEAR(MIN(Sheet1!B2:B500)), MONTH(MIN(Sheet1!B2:B500)), 1)

The order the projects appear in would not matter.

Solution can not be VBA as they might be looking to import this into Googlesheets.

Hopefully this is clear but if not, please let me know.

Any help would be appreciated.

 

[Special-K99]

Not saying I'll answer this
but it would be easier for formulas to have one project on one line, ie 1st Line June 18 July 18 are Bs, would be easier if they were As.
Any reason why you put dropped A in place of B on that line ?

Also your example data implies they are only TWO data ranges per project.

 

[Finalfight40]

Not saying I'll answer this
but it would be easier for formulas to have one project on one line, ie 1st Line June 18 July 18 are Bs, would be easier if they were As.
Any reason why you put dropped A in place of B on that line ?

Also your example data implies they are only TWO data ranges per project.

Hi Special-k99

The reason Project A got dropped for June and July is because the end date 1 month is April and it appears again on start date 2 in June hence the reason it reappears.

I am trying to avoid having them spaced out having a project per line as there are around 50 projects and growing and it would contain a lot of blank spaces.