Want a trace a same values exist in two different sheet
 

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

Want a trace a same values exist in two different sheet
 

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

Want a trace a same values exist in two different sheet
 

Wonder ful
Thanku very much sir


"Jacob Skaria" wrote:

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