Find out the date when the next match is played from a list

HI

I got a list of 60 cricket matches played in a season.(attached)
Total of 8 teams played all these matches.

Column L shows the teams that have lost (only 19 team matches) based on my own criteria.

I need to find out the dates for when these 19 teams played their next game, either as home or away team?

I have manually entered the dates , the expected results in column M.

Could someone please formulate to find the dates for next match played?

Thank you

attached now. Thank you for looking

Something is still going wrong somewhere. I don't see your workbook.

At the top of the page in the yellow banner are instructions on how to attach a workbook.
Would you like to try again?

Attached to this reply now mate.

Or try

=IF(L2="","",INDEX(A3:$A$60,MATCH("*"&L2&"*",B3:$B$60&"|"&C3:$C$60,0)))

both the formulas are working..GREAT

=IF(L2="","",INDEX(A3:$A$60,MATCH("*"&L2&"*",B3:$B$60&"|"&C3:$C$60,0)))

Nice short formula. But beware if there are teams participating where one name appears in the other name,
for example "Brisbane Heat" and "Brisbane Heat Juniors".
If such things happen, this formula is not suitable.

Originally Posted by HansDouwe

for example "Brisbane Heat" and "Brisbane Heat Juniors".
If such things happen, this formula is not suitable.

One way

=IF(L2="","",INDEX(A3:$A$60,MATCH(1,(L2=B3:$B$60)+(L2=C3:$C$60),0)))

Yes, this will work!

hi

Basically the file attached is a continuation of previous file attached.

What is the formula to find the date for 2nd game played?

Cheers