How To Check If Value Exists In Another Column Using excel formula ?

This article will be about how we can check if value exists in another column using formula in excel. This is a very powerful method which I came across when working with data where I had to do the same.

The task was to look whether the data from Column1 is present in column 2 , if yes then mark “exist” if not then mark “not exist”.

Let’s get straight into the task.

Formula used :

=IF(ISERROR(VLOOKUP(A2,$C$2:$C$4, 1, FALSE)),”Not Exist”,”Exist” )

I have used dummy data here.

Here , the formula is applied in Column B. We need to check if the records in Column C are present in Column A.

Hope you find it helpful!!!