Search code examples
excelcomparecontain

If a string contains the same value as cells k4:k7, give true

This is what I tried but this doenst work:

=ISNUMBER(SEARCH($K$4:$K$7;L4))

I want to check if E4 contains the same string as K4 thru K7. Is this somehow possible? I know that this is possible: =ISNUMBER(SEARCH(K4;L4))

Solution

  • =ISNUMBER(LOOKUP(1;0/SEARCH(L4;$K$4:$K$7)))

    Regards