Excel Formula

%3CLINGO-SUB%20id%3D%22lingo-sub-2773884%22%20slang%3D%22en-US%22%3EExcel%20Formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2773884%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20someone%20please%20help.%20How%20do%20i%20create%20a%20formula%20that%20reads%20what%20is%20in%205%20or%20more%20columns%20but%20data%20in%20the%20same%20row%2C%20that%20reads%20from%20a%20list%20in%20another%20sheet%20to%20tell%20me%20if%20those%20words%2Fvalues%20are%20present.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanking%20everyone%20in%20advance%20for%20the%20help.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2773884%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2773927%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2773927%22%20slang%3D%22en-US%22%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F795418%22%20target%3D%22_blank%22%3E%40NyxSA%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20can%20try%20it%20using%20MATCH()%20formula%3C%2FP%3E%3CP%3EBut%20I%20would%20suggest%20you%2C%20provide%20some%20sample%20data.%20Its%20not%20necessary%20be%20the%20original%20data%2C%20just%20some%20sample%20explaining%20your%20needs.%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-excel-formula%22%3E%3CCODE%3E%3DMATCH(WhatYouAreLookingFor%3BWhereTheDataAre%3B0)%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2773992%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2773992%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F795418%22%20target%3D%22_blank%22%3E%40NyxSA%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EA%20simple%20approach%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-excel-formula%22%3E%3CCODE%3E%3DCOUNTIF(Sheet1!%24A%241%3A%24E%2421%3BSheet2!A1)%26gt%3B0%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

Hi, 

 

Can someone please help. How do i create a formula that reads what is in 5 or more columns but data in the same row, that reads from a list in another sheet to tell me if those words/values are present.

 

Thanking everyone in advance for the help.

5 Replies

 

@NyxSA 

You can try it using MATCH() formula

But I would suggest you, provide some sample data. Its not necessary be the original data, just some sample explaining your needs.

=MATCH(WhatYouAreLookingFor;WhereTheDataAre;0)

 

Just added an example

@NyxSA 

A simple approach

=COUNTIF(Sheet1!$A$1:$E$21;Sheet2!A1)>0
The MATCH function works better than the CountIf. Thank you for your help.
No problem. Anytime.
By the way, if it worked, hit the like button and flag the post as solved.