Use a simple countif, assume you do this in sheet1 and the other list is in
sheet2, insert a new column next to the one in sheet1 assume the list is in A
and the new column is B
=IF(COUNTIF('Sheet2'!$A$1:$A$500,A1)0,"Exists","N on-existant")
copy down the formula
Regards,
Peo Sjoblom
"stevel" wrote:
I am trying to compare numbers in two different worksheets. In worksheet one
I have a list of number and in worksheet two I have a list of numbers, but I
want to know if a number appears in both worksheets. How do I do this?
Thanks in advance for your assistance.
|