formula to find if range contains a particular value

[nicoll]

I'm trying to come up with a formula to find if range contains a particular
value or text. I'm stuck can anyone help in Excel 2000.

Thanks.

 

[Ron Rosenfeld]

I'm trying to come up with a formula to find if range contains a particular
value or text. I'm stuck can anyone help in Excel 2000.

Thanks.

=COUNTIF(rng,"*" & text & "*")

Value can be a reference or a text string.

If the text string is numeric, then either the values in rng have to be text,
or the quoted asterisks need to be removed.


--ron

 

[JE McGimpsey]

One way:

=IF(COUNTIF(A1:A100,"particular value or text"), "Particular value
or text found", "Particular value or text not found")