matching a word within a text string

[catlow]

I am trying to lookup if a string match is true in a column and have it
return a value (or true). I have tried many different functions but
have not had success.

For example I have one column that includes various text strings and I
need to return all rows that contain a word "STOCK" within that string.
Examples of text strings include:
"0.0 Unknown using for STOCK"
"64.0 ACRES using 1,448.0 ACRE FEET PER ANUM for IRRIGATION"
"40.0 COWS / HORSES using for STOCK"


I have tried the following with the associated results following the
expression:

=IF("STOCK*", 1, IF("IRRIGATION*", 0, 1)) equals #VALUE

=IF(VLOOKUP("STOCK",AE2,1), 1, IF(VLOOKUP("IRRIGATION",AE2,1), 0, 1))
equals #value

=IF(VLOOKUP("STOCK",AE7,1) = TRUE, 1, IF(VLOOKUP("IRRIGATION",AE7,1) =
TRUE, 0, 1)) equals false "1"s

=OR(EXACT("STOCK",AE5)) equals all "false"

Any ideas???

Thanks

 

[J.E. McGimpsey]

one way:

=COUNTIF(rng,"*Stock*")

 

[catlow]

Thanks for the tip, however, I need to pull out individual instances i
order to use other attribute info associated with that occurance

 

[Harlan Grove]

Thanks for the tip, however, I need to pull out individual instances in
order to use other attribute info associated with that occurance.

See the FIND and SEARCH functions in online help.