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

Question

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))

score 1 · Answer 1 · answered Jul 07 '15 at 14:45

1

Try a match formula. It should be very similar to the way you're using the search formula.

=ISNUMBER(MATCH(L4,$K$4:$K$7,0))

answered Jul 07 '15 at 14:45

PermaNoob

Did you try replacing the commas in my formula with semicolons? – PermaNoob Jul 07 '15 at 14:51
Yes I did, even when I got `1` in K4 and `sdf1sdf` in M4 it doenst work anymore now ? With this: `=ISNUMBER(MATCH(L4;K4))` it outcomes `false`.. – wouter Jul 07 '15 at 14:52
1

@wouter: you told you look in L4 and mention M4 in the comment, please be more clear. if you want to check also part of the cell you need to use `"*"&L4&"*"`. – Máté Juhász Jul 07 '15 at 14:55

score 1 · Accepted Answer · answered Jul 07 '15 at 14:56

1

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

Regards

answered Jul 07 '15 at 14:56

XOR LX

2 Answers2