Want a trace a same values exist in two different sheet

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
 
J

Jacob Skaria

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
 
M

Mukesh

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Autonumber field in Excel that behaves the same as Access 0
comparing sheet to sheet and adding value 1
Combining two sheets of data into one and sorting by value - using macros 5
Auto populate cell with info on other cell (Sheet) 4
External cell reference between two excel worksheets both in One Drive 0
Match issue 3
Copy entire row from another sheet onto first sheet if a unique text matches 1
Match and delete rows on two different sheets from reference numbers 4

Top