find string in array with similar data

hi,
can you help me please?
I search function, which help me find data from column B in data in column A
f.e.
column A
1 car
2 bad
3 something
4 fish

column B
1 fi
2 play
3 thing
4 some

i want something like vlookup, but i dont search exactly "equal to", but "contain"
i want write to column C formula, that find in each row if is something similar in column B . In this example will be result something like:
C
1 YES
2 N/A
3 YES
4 YES

is this possible?

thx
ps. sorry for my very bad english

in this time i dont have a possibility to try your formula in excel 2003, because i want use it in work

at home i have only open office 3, but there wote it error:508
on monday a try it

thanke you very much i will try it later

hi,
this formula doesnt work for me:
=IF(COUNTIF($A$1:$A$4,"*"&B1&"*"),"YES","n/a")

When i give "enter" after i write it, it doesnt show any error, but it highlight in formula this part "$A$4,"" and thats all.

if i escape it, formula is in cell, but only as text.

can you help me?
thx

yes, this works great.
OK, i try it based on this file.
thanke you very much.


this is very good web