Excel Formula Help

[asripinyo]

Hello, I am looking for a specific formula to find if a value found in 1 cell is present in another cell that may have multiple values in it, separated by comma.

Example. In cell B2, the value says "Finance", and in cell C2, the value reads "Cancer, Finance, Food"... I would like to run this on a list of 5,000 rows, to see if the value found in B2 is found somewhere in C2. 

Thank you!

[#2 · Accepted solution]

@asripinyo 

It could be

with

=IF(COUNTIF(C2, "*"&B2&"*"), "here", "not here")

[#3]

Thank you very much, that worked!

[#4]

@asripinyo , glad it helped