matching a word within a text string

  • Thread starter Thread starter catlow
  • Start date Start date
C

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
 
Thanks for the tip, however, I need to pull out individual instances i
order to use other attribute info associated with that occurance
 
Thanks for the tip, however, I need to pull out individual instances in
order to use other attribute info associated with that occurance.
Click to expand...

See the FIND and SEARCH functions in online help.
 
Back
Top