Hi!

Try this:

=ISNUMBER(SEARCH(G2,N2))*1

Biff

"Karen53" wrote in message
...
Hello,

I need to compare for a value contained within another cell. I need to
test
for a portion within the cell so I'm using wildcards. I have tried
various
combinations but it's not working. What am I missing?

Here is one I've tried.

=IF(n2=*g2*,1,0)

Thanks for your help,