=CONTAINS("Spreadsheet Lisp", "Lisp")
-> TRUE
DEFINE(
CONTAINS,
LAMBDA(
haystack,
needle,
IF(
AND(
EQUAL(
COUNTA(haystack),
1),
EQUAL(
COUNTA(needle),
1)),
ISNUMBER(
SEARCH(
needle,
haystack)),
OR(
EXACT(
needle,
haystack)))))
Help us optimize this function