Want a trace a same values exist in two different sheet

  • Thread starter Thread starter Mukesh
  • Start date Start date
M

Mukesh

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
 
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
 
Wonder ful
Thanku very much sir


Jacob Skaria said:
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
Click to expand...
 
Back
Top