Assuming you have loan numbers in Sheet1 ColA and Sheet2 ColA. Try the below
in Sheet1 - Cell B1

=IF(COUNTIF(Sheet2!A:A,A1)0,"Exists","")

If this post helps click Yes
---------------
Jacob Skaria


"Mukesh" wrote:

I have two sheet , I want to know if the value in a colomn of a sheet is
exist in other sheet also.

say the value is loan number if the same loan number is exist in another
sheet than it should be highlighted in the first sheet