Matching multiple criteria that includes comma separated value

[Rokcmd]

Hello - I'm looking for a formula to confirm a match between multiple criteria when one of the lookup arrays has comma separated values. For ex. in the screenshot below, if C2 & D2 match with the arrays A2:A4 & any of its adjacent comma separated values in B2:B4, the formula would return "Match".

 

[hagia_sofia]

Not sure whether the following will cover it all but you can test it:

=MAP(C2:C7,D2:D7,LAMBDA(x,y,IF(SUM(--(y=--(TEXTSPLIT(XLOOKUP(x,$A$2:$A$7,$B$2:$B$7),", "))))>0,"Match","No Match")))

 

[Rokcmd]

That worked! Thank you