Find if value in column A contains value from column B ?

Find if value in column A contains value from column B ?

Asked on January 10, 2019 in Excel.
Add Comment


  • 3 Answer(s)

    You can try either this solution

    =IF(ISNA(VLOOKUP(<single column I value>,<entire column E range>,1,FALSE)),FALSE, TRUE)
    

    Or this solution

    =IF(ISNA(VLOOKUP(<single column I value>,<entire column E range>,1,FALSE)),"FALSE", "File found in row " & MATCH(<single column I value>,<entire column E range>,0))

        Use this easiest way to replace <single column I value> and <entire column E range> along named ranged.

    Drag that syntax all the way down the length of the I column in any column you need.

    Answered on January 10, 2019.
    Add Comment

        By using  VLOOKUP, although it needs a wrapper function to return True or False. Not to identify it is slow. Alternatively use COUNTIF or MATCH.

     From I1 to I2691 use this syntax in column K next to the actual values in column I

    =COUNTIF(<entire column E range>,<single column I value>)>0
    =COUNTIF($E$1:$E$99504,$I1)>0
    

    As well as you can use MATCH:

    =NOT(ISNA(MATCH(<single column I value>,<entire column E range>)))
    =NOT(ISNA(MATCH($I1,$E$1:$E$99504,0)))
    
    Answered on January 10, 2019.
    Add Comment

    Try this alternative solution :

    =IF(ISNUMBER(MATCH(I1,E:E,0)),"TRUE","")
    
    
    Answered on January 10, 2019.
    Add Comment


  • Your Answer

    By posting your answer, you agree to the privacy policy and terms of service.