If function?
=if(countif(A1,"*Catalog*"),"Catalog",if(countif(A 1,"*Stock*"),"Stock","not
found"))
--
Regards,
Tom Ogilvy
"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
|