Need help finding a substring in a array of strings.

[hvcrios]

This is driving me insane, all I want to do is check whether th
information contained in a cell is present in an array of cells or not
it's substring and I'm checking against an array of strings, but it jus
wont fu#$%@ work.... I'm using this
=IF(NOT(ISERROR(FIND(A1;$C$1:$C$388;1)));"true";"false") that's all, i
it finds the substring it should return true else false, the thing i
that the substring is actually a numeric sequence, here's an example o
the worksheet

----A------------------B----------------------
1 1234-------------FUNCTION-----------5678_hh_buzzz
2 5678-------------FUNCTION-----------9866_hh_buzzz
3 9866-------------FUNCTION-----------1237_hh_buzzz
4 5248-------------FUNCTION-----------9975_hh_buzzz
5 1237-------------FUNCTION-----------0832_hh_buzzz


so I'm checking if values from column A are present in any of the value
of column C, using the aforementioned function on column B, it wil
return false for all, even for the ones I KNOW are there, the funn
things is that if I change the search text to "hh" or "buzzzz" it wil
return true, it seems to be having problems with the numbers somehow

Anyone knows what might be the problem

 

[Claus Busch]

Hi,

Am Fri, 16 Nov 2012 19:13:38 +0000 schrieb hvcrios:

----A------------------B----------------------C
1 1234-------------FUNCTION-----------5678_hh_buzzzz
2 5678-------------FUNCTION-----------9866_hh_buzzzz
3 9866-------------FUNCTION-----------1237_hh_buzzzz
4 5248-------------FUNCTION-----------9975_hh_buzzzz
5 1237-------------FUNCTION-----------0832_hh_buzzzz

try:
=COUNTIF($C$1:$C$388,A1&"*")>0


Regards
Claus Busch