Formula for a cell that contains one of two things

[MistyWind]

I'm looking for a formula that will help me add a value to help me categorize page type. Column 1 contains url paths and I'd like column 2 to contain either "Products" or "Content". If column A contains "/collections/" or contains "/products/" it could be classified as "Products" in column B. If neither of these are detected, then column B would be populated as "Content". Thanks for any help.

Page	Page Type
/collections/back-packs	Products
/faq	Content
/collections/tents	Products
/products/product-a	Products
/collections/cooking	Products
/products/product-b	Products

 

[etaf]

how about in B2 and copy down
=IF(A2="","",IF(OR(ISNUMBER(SEARCH("collection",A2,1)),ISNUMBER(SEARCH("product",A2,1))),"Products","Content"))

I have put in C2 - so you can compare

Book4
	A	B	C
1	Page	Page Type
2	/collections/back-packs	Products	Products
3	/faq	Content	Content
4	/collections/tents	Products	Products
5	/products/product-a	Products	Products
6	/collections/cooking	Products	Products
7	/products/product-b	Products	Products
8
9
10
Sheet1

Cell Formulas
Range	Formula
C2:C10	C2	=IF(A2="","",IF(OR(ISNUMBER(SEARCH("collection",A2,1)),ISNUMBER(SEARCH("product",A2,1))),"Products","Content"))

 

[kweaver]

One option:

=IF(OR(ISNUMBER(SEARCH("/collections/",A2)),ISNUMBER(SEARCH("/products/",A2))),"Products","Content")

 

[MistyWind]

how about in B2 and copy down
=IF(A2="","",IF(OR(ISNUMBER(SEARCH("collection",A2,1)),ISNUMBER(SEARCH("product",A2,1))),"Products","Content"))

I have put in C2 - so you can compare

Book4
	A	B	C
1	Page	Page Type
2	/collections/back-packs	Products	Products
3	/faq	Content	Content
4	/collections/tents	Products	Products
5	/products/product-a	Products	Products
6	/collections/cooking	Products	Products
7	/products/product-b	Products	Products
8
9
10
Sheet1

Cell Formulas
Range	Formula
C2:C10	C2	=IF(A2="","",IF(OR(ISNUMBER(SEARCH("collection",A2,1)),ISNUMBER(SEARCH("product",A2,1))),"Products","Content"))

This worked great for me. Because I'm new to formulas, can you explain to me the use of "","" at the front of the formula and also why the use of "1"?

 

[MistyWind]

One option:

=IF(OR(ISNUMBER(SEARCH("/collections/",A2)),ISNUMBER(SEARCH("/products/",A2))),"Products","Content")

This is great. Looks to be what I was trying to put together but I had a hard time figuring out how to add two different possibilities.

 

[etaf]

if you copy the formula down the column as many rows as you like - there is a chance that it will probably find cells in column A that are blank
as i have shown

if a row is blank then it does not contain Product or collection and so false
in which case for blank cells in column A - it will be false and return Content - when in fact you have no data entered

you can see the difference in column C / D

Book4
	A	B	C	D
1	Page	Page Type	with ""	without ""
2	/collections/back-packs	Products	Products	Products
3	/faq	Content	Content	Content
4	/collections/tents	Products	Products	Products
5	/products/product-a	Products	Products	Products
6	/collections/cooking	Products	Products	Products
7	/products/product-b	Products	Products	Products
8				Content
9				Content
10				Content
11				Content
12				Content
13				Content
Sheet1

Cell Formulas
Range	Formula
C2:C13	C2	=IF(A2="","",IF(OR(ISNUMBER(SEARCH("collection",A2,1)),ISNUMBER(SEARCH("product",A2,1))),"Products","Content"))
D2:D13	D2	=IF(OR(ISNUMBER(SEARCH("collection",A2,1)),ISNUMBER(SEARCH("product",A2,1))),"Products","Content")