FORMULA - TO CHECK TO SEE WHETHER PART OF TEXT WITHIN A CELL APPEARS ON ANOTHER LIST

%3CLINGO-SUB%20id%3D%22lingo-sub-2985198%22%20slang%3D%22en-US%22%3EFORMULA%20-%20TO%20CHECK%20TO%20SEE%20WHETHER%20PART%20OF%20TEXT%20WITHIN%20A%20CELL%20APPEARS%20ON%20ANOTHER%20LIST%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2985198%22%20slang%3D%22en-US%22%3E%3CP%3ESo%20I%20have%20an%20excel%20spreasheet.%20There%20is%20a%20Customer%20Column%20which%20shows%20the%20'Account%20Code%20-%20Customer%20Name'%20.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20Account%20Code%20is%20between%206%20and%208%20digits.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20need%20to%20check%20to%20see%20whether%20this%20account%20code%20appears%20on%20a%20different%20list.%20if%20it%20does%2C%20then%20a%20yes%20appears.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20struggling%20to%20do%20it%2C%20as%20the%20account%20code%20is%20the%20same%20number%20of%20digits%20for%20each%20line.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20ideas%3F%20Thank%20you%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2985198%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-2985922%22%20slang%3D%22en-US%22%3ERe%3A%20FORMULA%20-%20TO%20CHECK%20TO%20SEE%20WHETHER%20PART%20OF%20TEXT%20WITHIN%20A%20CELL%20APPEARS%20ON%20ANOTHER%20LIST%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2985922%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1223966%22%20target%3D%22_blank%22%3E%40SLCLARKE23%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20may%20check%20with%20COUNTIF()%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-excel-formula%22%3E%3CCODE%3E%3DCOUNTIF(account%20list%2C%20%22*%22%20%26amp%3B%20AccountCode%20%26amp%3B%20%22*%22)%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E
New Contributor

So I have an excel spreasheet. There is a Customer Column which shows the 'Account Code - Customer Name' .

 

The Account Code is between 6 and 8 digits.

 

I need to check to see whether this account code appears on a different list. if it does, then a yes appears.

 

I am struggling to do it, as the account code is the same number of digits for each line.

 

Any ideas? Thank you

1 Reply

@SLCLARKE23 

You may check with COUNTIF()

=COUNTIF(account list, "*" & AccountCode & "*")