Index Match partial text with multiple criteia

[Tenkaku]

Hi,

I'd appreciate if anyone could help correct the below formula I have written.

=INDEX(Daily[Date],MATCH(1,(("*"&Mem_Payment[Name]&"*"=Daily[Detail])*(Daily[Membership]<>"")*(Daily[Date]>=H$1)*(Daily[Date]<=H$2)),0))

Basically I was trying to use INDEX/MATCH to look up all names from G that contains in B and return the result from A
In addition, there are multiple criterias:
1) For every B, D can't be blank
2) Return results in H should be dates in A that are within H Starting date and ending date. Same for column I.

In the file, I have manually put the final value that it should be.

Hope I make some sense, since I personally got lost in there.

Thanks in advance.

[bebo021999]

Create name: Min and Max to get the first and last date:

Min:
=AGGREGATE(15,6,Daily[Date]/(LEN(","&SUBSTITUTE(Daily[Detail],", ",",")&",")-LEN(SUBSTITUTE(","&SUBSTITUTE(Daily[Detail],", ",",")&",",","&Sheet1!$G4&",",""))>0),1)
change 15,6 to 14,6 for Max

Then in H4:
=IF(Min>=$I$1,"",Min)

I4:
=IF(Max<$I$1,"",Max)

[Tenkaku]

Wonderful!
Though this is another level of approaching it. It will take me a while to understand it.
For now, I shall apply it in the original complexed data and hope that it works after some minor adaptations.
Thanks a lot Bebo.