Comparing data between worksheets

[Peter D]

I am trying to compare data between two quite large excel
worksheets; and on a third show the results. Basically I
need to know whether the data is the same between
comparable cells; or whether it is different which could
include one of around ten different permutations of
differences. Each possibility would be allocated a code and
this put in the equivalent cell on the third spreadsheet.
How can this be done?

 

[Peo Sjoblom]

You can go to Chip Pearson's site and download a utility called
Compare written by Myrna Larsson and Bill Manville

http://www.cpearson.com/excel/download.htm

 

[R Snyder]

By the use of the term permutations I would have to assume
that the number of occurrences of pairing could be quite
extensive, is this true? Another words you have 10
potential values that can be assessed to a key value found
in both sheets. If the permutation includes not only the
occurrence of a particular value but also the placement
(sheet 1 versus sheet 2) then you need to capture more
than just an equal comparison (ie., Sheet1!A1 = "B" and
Sheet1!A1 = "B"). Using a sample subset of just 3 values
those being "A" through "C" you could have a comparison
results of (A,A), (A,B), (A,C), (B,A), (B,B), (B,C),
(C,A), (C,B), (C,C). Is this what your trying to derive
in order allocate a code? Let me know and if so I would
suggest a couple of tables and then some vlookup formulas
along with IF/THEN statements.

 

[Peter D]

That is exactly what I am after. The data I am comparing is
(A,A), (A,B), (A,C), (A,D), (B,A), (B,B), (B,C), (B,D),
(C,A), (C,B), (C,C); each needing a unique code. If you can
help with the formulae I need and vlookup terminology that
would be appreciated.

Thanks for response (and to others as well) to this
request.