One more thing to say is that if you find the error message disturbing, you
can enter this formula in D1:

=IF(ISERROR(C1),"Not Found","Found")

and format C1 with white font color.

--
Kristoffer Andreas Berg
Programmer on a hobby basis
http://home.online.no/~gunnarab


"Hakojin" wrote:

thank you very much, worked perfect. I was trying much more complicated
formulas and it was so simple.

"Kristoffer Andreas Berg" wrote:

Assuming 8752 is in A1 and "Irr Ltd fxd 3609..." is in B2 you can enter this
formula in C1 to look up 8752:

=SEARCH(A1,B1)

If the text is found, the function returns the number of the character where
the text is first found. If it is not, a #VALUE! error message is displayed.