Formula HELP- From A group Need to do a vlookup

%3CLINGO-SUB%20id%3D%22lingo-sub-1814126%22%20slang%3D%22en-US%22%3EFormula%20HELP-%20From%20A%20group%20Need%20to%20do%20a%20vlookup%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1814126%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%20analyze%20a%20list.%26nbsp%3B%3C%2FP%3E%3CP%3EColumn%20A%20is%20a%20unique%20identifier.%20I%20want%20to%20group%20the%20sheet%20by%20this%20identifier.%26nbsp%3B%3C%2FP%3E%3CP%3EThen%20I%20want%20to%20do%20a%20vlookup%20or%20If%20I%20think.%20That%20says%20in%20the%20group%20of%20similar%20Ids%20(1-5%20results%20normally)%20of%20those%20in%20that%20group%20of%20that%20unique%20Id%20-%20How%20many%20of%20Column%20C%20%3D%20%22exact%20Text%22%20return%20Yes.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20If%20the%20Unique%20Id%20in%20Column%20A%20%3D1%20and%20has%203%20rows%20that%20%3D1%20in%20Column%20A%20..%20then%20of%20those%20three%20rows%26nbsp%3B%20do%20any%20of%20them%20have%20%22Specific%20Text%22%20in%20Column%20C%20-%20If%20so%20return%20Yes.%20Then%20go%20to%20the%20next%20group%20of%20Unique%20Id%20from%20Column%20A%20and%20repeat%20function%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20help..%20Because%20the%20data%20contains%20PII%20I%20can't%20share..%20But%20any%20help%20would%20be%20appreciated.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1814126%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1814512%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%20HELP-%20From%20A%20group%20Need%20to%20do%20a%20vlookup%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1814512%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F844158%22%20target%3D%22_blank%22%3E%40TGoodnight%3C%2FA%3E%26nbsp%3B%3A%20Hi%2C%20I%20tried%20using%20Countifs%20to%20solve%20this%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I am trying to analyze a list. 

Column A is a unique identifier. I want to group the sheet by this identifier. 

Then I want to do a vlookup or If I think. That says in the group of similar Ids (1-5 results normally) of those in that group of that unique Id - How many of Column C = "exact Text" return Yes. 

 

So If the Unique Id in Column A =1 and has 3 rows that =1 in Column A .. then of those three rows  do any of them have "Specific Text" in Column C - If so return Yes. Then go to the next group of Unique Id from Column A and repeat function

 

Please help.. Because the data contains PII I can't share.. But any help would be appreciated. 

1 Reply

@TGoodnight : Hi, I tried using Countifs to solve this