=IF(COUNTIF(A1,"*stock*"),"stock",IF("COUNTIF(A1," *catalog*"),"Catalog","Nei
ther"))


--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Paul" wrote in message
...
Thanks chips, but what happens with my other variable?

"Chip Pearson" wrote:

Try

=IF(COUNTIF(A1,"*stock*"),"stock","no stock")


"Paul" wrote in message
...
Newbie question...I'm looking for the formula that will report
the value that
I want in column B. I guess wildcards must nbe used. I tried
=IF (A1 =
"*Catalog*", "Catalog", IF(A1 = "*Stock*", "Stock"))

A B
Stock - Rock Stock
Catalog - Indie Catalog
Catalog - Rock Catalog
Stock - Indie Stock

Thanks for your help.

Paul