SOLVED

Excel Formula Help

%3CLINGO-SUB%20id%3D%22lingo-sub-2432331%22%20slang%3D%22en-US%22%3EExcel%20Formula%20Help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2432331%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%20I%20am%20looking%20for%20a%20specific%20formula%20to%20find%20if%20a%20value%20found%20in%201%20cell%20is%20present%20in%20another%20cell%20that%20may%20have%20multiple%20values%20in%20it%2C%20separated%20by%20comma.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EExample.%20In%20cell%20B2%2C%20the%20value%20says%20%22Finance%22%2C%20and%20in%20cell%20C2%2C%20the%20value%20reads%20%22Cancer%2C%20Finance%2C%20Food%22...%20I%20would%20like%20to%20run%20this%20on%20a%20list%20of%205%2C000%20rows%2C%20to%20see%20if%20the%20value%20found%20in%20B2%20is%20found%20somewhere%20in%20C2.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2432331%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2432390%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Formula%20Help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2432390%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1075049%22%20target%3D%22_blank%22%3E%40asripinyo%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIt%20could%20be%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20561px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F287582iE8D062F68FCA45F5%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3Ewith%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-excel%22%3E%3CCODE%3E%3DIF(COUNTIF(C2%2C%20%22*%22%26amp%3BB2%26amp%3B%22*%22)%2C%20%22here%22%2C%20%22not%20here%22)%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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!

3 Replies
best response confirmed by asripinyo (New Contributor)
Solution

@asripinyo 

It could be

image.png

with

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

 

Thank you very much, that worked!

@asripinyo , glad it helped