Hi - I'm trying to put together a Booking Calendar but have come across a problem in that every Friday is a cross over day and ideally I need both names appearing in one cell. I am using the following formula to transfer the details from the "Bookings" sheet to the calendar. - =IFERROR(INDEX(Bookings!$C$2:$C$200,MATCH(1,(Bookings!$A$2:$A$200<=A7)*(Bookings!$B$2:$B$200>=A7),0)),"")
However, when I run this through, only "John" appears in A10. I imagine it may be impossible to get the two names in A10 but any ideas would be appreciated.
[TABLE="width: 764"]
<colgroup><col><col span="7"></colgroup><tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD]G[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Bookings[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Date From[/TD]
[TD]Date To[/TD]
[TD]Name[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]22/12/2017[/TD]
[TD]29/12/2017[/TD]
[TD]John[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]29/12/2017[/TD]
[TD]04/01/2018[/TD]
[TD]Jill[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]Sheet 2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]22/12/2017[/TD]
[TD]23/12/2017[/TD]
[TD]24/12/2017[/TD]
[TD]25/12/2017[/TD]
[TD]26/12/2017[/TD]
[TD]27/12/2017[/TD]
[TD]28/12/2017[/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]John[/TD]
[TD]John[/TD]
[TD]John[/TD]
[TD]John[/TD]
[TD]John[/TD]
[TD]John[/TD]
[TD]John[/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]29/12/2017[/TD]
[TD]30/12/2017[/TD]
[TD]31/12/2017[/TD]
[TD]01/01/2018[/TD]
[TD]02/01/2018[/TD]
[TD]03/01/2018[/TD]
[TD]04/01/2018[/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD]John/Jill[/TD]
[TD]Jill[/TD]
[TD]Jill[/TD]
[TD]Jill[/TD]
[TD]Jill[/TD]
[TD]Jill[/TD]
[TD]Jill[/TD]
[/TR]
</tbody>[/TABLE]
However, when I run this through, only "John" appears in A10. I imagine it may be impossible to get the two names in A10 but any ideas would be appreciated.
[TABLE="width: 764"]
<colgroup><col><col span="7"></colgroup><tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD]G[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Bookings[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Date From[/TD]
[TD]Date To[/TD]
[TD]Name[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]22/12/2017[/TD]
[TD]29/12/2017[/TD]
[TD]John[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]29/12/2017[/TD]
[TD]04/01/2018[/TD]
[TD]Jill[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]Sheet 2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]22/12/2017[/TD]
[TD]23/12/2017[/TD]
[TD]24/12/2017[/TD]
[TD]25/12/2017[/TD]
[TD]26/12/2017[/TD]
[TD]27/12/2017[/TD]
[TD]28/12/2017[/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]John[/TD]
[TD]John[/TD]
[TD]John[/TD]
[TD]John[/TD]
[TD]John[/TD]
[TD]John[/TD]
[TD]John[/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]29/12/2017[/TD]
[TD]30/12/2017[/TD]
[TD]31/12/2017[/TD]
[TD]01/01/2018[/TD]
[TD]02/01/2018[/TD]
[TD]03/01/2018[/TD]
[TD]04/01/2018[/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD]John/Jill[/TD]
[TD]Jill[/TD]
[TD]Jill[/TD]
[TD]Jill[/TD]
[TD]Jill[/TD]
[TD]Jill[/TD]
[TD]Jill[/TD]
[/TR]
</tbody>[/TABLE]