You can use MATCH( ) or VLOOKUP( ) to search for text in a column.
Something like:

=IF(MATCH(Sheet1!B2,A1:A10,0),Run Numeric Statement,0)

might give you what you want, but I don't understand what you mean by
"Run Numeric Statement". If the word in Sheet1!B2 does not appear in
the range A1:A10, you will get the #N/A error message.

Hope this helps.

Pete