Assuming the below

1) Report 1 in Sheet1 A1:J100
2) Report 2 in Sheet2 A1:J100
3) Sheet3 has the header fields in Row1 and Column 1

use this formula in Sheet3 B2 which will return a 1 if there is a mismatch
between
Sheet1 and Sheet2 for the corresponding headers..

=IF(INDEX(Sheet1!$A$1:$J$100,MATCH($A2,Sheet1!$A$1 :$A$100,0),MATCH(B$1,Sheet1!$A$1:$J$1,0))=INDEX(Sh eet2!$A$1:$J$100,MATCH($A2,Sheet2!$A$1:$A$100,0),M ATCH(B$1,Sheet2!$A$1:$J$1,0)),"",1)


Alternatively, if you have the headers in the same cell location in all
sheets you can try out this formula in Sheet3 B2

=IF(Sheett1!B2=Sheet2!B2,"",1)

If this post helps click Yes
---------------
Jacob Skaria


"Jim" wrote:

Hello,

I need help with match formulas that will return discrepancies between two
reports.

I would like a third table that will return the account number when data
from one of the adjacent columns do not match. Although 1183-06 matches,
some
of them do not. I gave you a sampling of the spreadsheet, there are several
dozens rows.

For example:
Report One:
. ..577
386-05..... 1 .... 1 ..... .... .... 1 ......
455-05..... 1 .... 1 ..... .... .... 1 ......

Report Two:
. ..577
386-05..... 1 .... ..... .... .... 1 ......
455-05..... 1 .... 1 ..... .... .... 1 ......

Return
. ..577
386-05..... .... 1 ..... .... .... ......

The result will be a third table that shows me that 386-05 did not have a
count for column 325.

I hope this example helps.
and thanks so much.

Jim