CODEWITHSUNDEEP
excelexcel-formula
user245255
user245255

Reputation: 325

Check Or Find If Value Exists In Another Column

It should be very easy but I just can not understand whats wrong anymore. I have 3 columns, first and third column has numbers and I want the second column to show if a number in column 1 exists in column 3. I have found a code online

=IF(ISERROR(VLOOKUP(A7;$C$2:$C$3400; 1; FALSE));"Not Exist";"Exist" )

Now I know the number "5568" exist in A7 and the same number "5568" exists in C2365.

But the code above gives me value "Not Exist".

Upvotes: 4

Views: 31482

Answers (1)

Error 1004
Error 1004

Reputation: 8220

Try:

Sheet Structure:

enter image description here

Formula:

=IF(COUNTIF($C$1:$C$5,A1)>0,"Exist","Not Exists")

Note:

  • Check for spaces before or after the values using Trim
  • You could also use Clean

Upvotes: 8

Related Questions