how to find a value in a column

[thaimic]

Hi all,

I have an excel file that I want to find a value at a column if has so return 1 and else 0.
Please help to make it.
Thank you so much

[FDibbins]

Try this, copied down...
=--(COUNTIF($B$2:$B$8,"*"&A2&"*")>0)

[Norie]

Try this.

=--NOT(ISNA(MATCH("*"&A2&"*",$B$2:$B$8,0)))

[FDibbins]

Thanks for the rep, if that answers your question, please mark your thread as SOLVED using Thread Tools (located above your first post).
Thanks.