Adding "SEARCH" function to this multi-criteria Index-Match

[RockandGrohl]

This is the Index Match with multiple criteria I'm using;

{=INDEX(range1,MATCH(1,(A1=range2)*(B1=range3),0))}

So two criteria. For the first criteria it's going to be a lookup value to range match, so like "Cotswold Adventure" will match with "Cotswold Adventure"

For the second criteria, it's got to match within a list. I'm trying to look up "Luton" amongst a list inside one cell that looks like this:

[TABLE="width: 565"]
<tbody>[TR]
[TD]"Oxford, Oxford Services (M40), Oxford Peartree Services (A34), Thame, Aylesbury, Leighton Buzzard, Dunstable, Luton, Stevenage, Letchworth, Cambridge"[/TD]
[/TR]
</tbody>[/TABLE]
[FONT=Verdana]

In terms of specific syntax, this is what I have, which failed:

[/FONT]

{=INDEX('[Price Panels 2019.xlsm]All Tours'!$A:$A,MATCH(1,(H2='[Price Panels 2019.xlsm]All Tours'!$C:$C)*(G2=SEARCH(G2,'[Price Panels 2019.xlsm]All Tours'!$K:$K)),0))}

Hope there is a solution. I'm aware that my search result is bringing back "111" when used on its own, instead of what I need. Maybe a nested IF?

Thanks!

 

[RockandGrohl]

Got it in the end:

{=IFERROR(INDEX(LEFT('[Price Panels 2019.xlsm]All Tours'!$A:$A,6),MATCH(1,(H2='[Price Panels 2019.xlsm]All Tours'!$C:$C)*ISNUMBER(SEARCH(G2,'[Price Panels 2019.xlsm]All Tours'!$K:$K)),0)),"")}