What Function Do I use.

[frsydtke]

I have spent all afternoon and failed to find the correct formula.
Reaching out for some help.

We have a basic excel with 2 Column and 5000 rows.
Column B is our SKU - FCA001, FCA002,FCA003 and so on.
Column C is our image links example below.

I am trying to find a rule to check the SKU "Column B" is contained in the adjacent row "Column C"

Is that possible please? Thank you in advance......!

<colgroup><col style="mso-width-source:userset;mso-width-alt:5412;width:111pt" width="148"> <col style="mso-width-source:userset;mso-width-alt:5156;width:106pt" width="141"> <col style="width:48pt" width="64"> </colgroup><tbody>
[TD="class: xl65, width: 148, align: center"]#NAME?[/TD]
[TD="class: xl66, width: 141"]FCA001[/TD]
[TD="width: 64"]https://cdn-share.slickpic.com/u/PhillipHume/LO1/org/FCA001Anderson/p/MTQ3
[/TD]

</tbody>

 

[Scott T]

Re: Help - What Function Do I use.

If I understand what you want correctly this should work

Excel 2010
	A	B	C
2	links has SKU	FCA001	https://cdn-share.slickpic.com/u/PhillipHume/LO1/org/FCA001Anderson/p/MTQ3
Sheet1

Cell Formulas
Range	Formula
A2	=IF(ISNUMBER(SEARCH(B2,C2)),"links has SKU","Link does NOT have SKU")

 

[frsydtke]

Thank you!!!!!

 

[Scott T]

You are welcome.