find a date in between 2 different dates for a repeated customer entry

[Francis80]

Hi,

Please find the attached file.

I have 2 sheets in it.

first sheet is "Entry", where I have the entries of the customer's booked dates. I have repeated customers have booked for the show for some days (Eg: customer "C" booked


Customer Start Date End Date
C 02-Feb-15 05-Feb-15

C 23-Feb-15 27-Feb-15

In sheet to I have the customer's name in unique.

I want to display "B" for which dates the customer booked for ..

Can any one help me to put the formula here.

-Francis

 

[Hui]

In Status worksheet B2:
=IF(SUMPRODUCT((Entry!$A$2:$A$19=$A2)*(Entry!$B$2:$B$19<=B$1)*(Entry!$C$2:$C$19>=B$1)),"B","")
Copy across and down

 

[Syedali]

Hi Francis,

My try.

=IFERROR(INDEX(Entry!$C$2:$C$19,MATCH(Status!$A2&Status!B$1,Entry!$A$2:$A$19&Entry!$B$2:$B$19,0)),"")
+Ctrl+shift+Enter

 

[Francis80]

Thanks HUI....
you are simply superb..!
It works fine.

I Uploaded a file, Just a small gift.
which I have created on my own.

 

[Francis80]

My hearty wishes and many thanks to HUI and Chandoo.org