IF Formula Help

%3CLINGO-SUB%20id%3D%22lingo-sub-2642156%22%20slang%3D%22en-US%22%3EIF%20Formula%20Help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2642156%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3EI%20need%20help%20trying%20to%20find%20a%20specific%20formula...%20In%20column%20A%2C%20I%20have%20many%20rows%20(450)%20of%20specific%20values%2C%20all%20unique...%20In%20column%20B%2C%20I%20have%20many%20rows%20(40%2C000)%20that%20has%20various%20values%2C%20some%20separated%20by%20comma.%20I%20am%20looking%20for%20a%20formula%20that%20would%20tell%20me%20if%20a%20value%20in%20column%20A%20is%20found%20in%20any%20cell%20in%20column%20B.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EExample%20and%20ideal%20solution%20(column%20C)%20attached.%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-2642156%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-2642380%22%20slang%3D%22en-US%22%3ERe%3A%20IF%20Formula%20Help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2642380%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%3E1)%20%22Operational%20Pathways%22%20won't%20match%20%22Operation%20Pathways%22%20-%20you'd%20need%20a%20fuzzy%20match%20add-in%20for%20that.%3C%2FP%3E%0A%3CP%3E2)%20The%20%22ideal%20results%22%20in%20column%20C%20appear%20to%20show%20whether%20one%20of%20the%20strings%20in%20a%20cell%20in%20column%20B%20occurs%20in%20any%20cell%20in%20column%20A%20instead%20of%20the%20other%20way%20round...%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hello,

I need help trying to find a specific formula... In column A, I have many rows (450) of specific values, all unique... In column B, I have many rows (40,000) that has various values, some separated by comma. I am looking for a formula that would tell me if a value in column A is found in any cell in column B.

 

Example and ideal solution (column C) attached.

 

Thank you!!

1 Reply

@asripinyo 

1) "Operational Pathways" won't match "Operation Pathways" - you'd need a fuzzy match add-in for that.

2) The "ideal results" in column C appear to show whether one of the strings in a cell in column B occurs in any cell in column A instead of the other way round...