Look at a combination of IF, ISNUMBER and MATCH: =IF(ISNUMBER(MATCH([sheet1
reference,[sheet two range],0)),"match","no match")

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"Jerim79" wrote:

I have searched for any previous topics that may have already answered
this, but didn't find any.

I am running Excel 97. I have two spreadsheets. One is the 2006
version and the other is the 2007 version. It is a list of customers.
We want to see how many customers are on both the 2006 and the 2007
spreadsheets. The only comparison tips/programs/tools I have seen, do
just a line by line comparison. That works great if you the rows are
exactly the same, in the same order and you just want to see what data
has changed. However, my two spreadsheets may not have the same
ordering. Even when sorted, we may have added/deleted customers that
throws the order off completely from the other spreadsheet. Since a
customer may be on both spreadsheets, just not on the same row, all
the tools/tips/programs I have used so far have found every line to be
different.

What I need is something that will take the value of cell A1 from
Spreadsheet 1 and compare it against cells A1-A1000 on Spreadsheet 2,
looking for a match. Then take cell A2 from Spreadsheet 1 and compare
it against cells A1-A1000 on Spreadsheet 2, looking for a match. And
so on and so on and so on. Any help would be appreciated.