Google sheets, how do I get regexmatch to find a text string in a list?-CodePudding

Home > database > Google sheets, how do I get regexmatch to find a text string in a list?

Google sheets, how do I get regexmatch to find a text string in a list?

Time：05-20

I am new here, I have tried search for this answer and I can't find the same question

I am a totally self taught spreadsheet-maker, so if I have done some weird stuff - Please don't judge too harshly!

So I am using REGEXMATCH, and it just doesn't seem to be working like it usually does, and I can't work out why.

=IF($A13="","",(IF(REGEXMATCH({$L$13:$L$18},$A13),"YES","NO")))

I have made a workbook example to show the dilemma-