Assuming the intersection of...
Table A
Row 'A3' and Column 'BOX050' is Cell B2
Table B
Row 'A3' and Column 'BOX050' is Cell B8
Table C
Row 'A3' and Column 'BOX050' is Cell B14

In Cell B14, put...
=if(b2<b8,"Check","")

Copy B14 to the rest of Table C

HTH,
--
Gary Brown

If this post was helpful to you, please select 'YES' at the bottom of the
post.



"carl" wrote:

I have 2 tables:

TableA BOX050 BOX060 BOX355
A3 1 1
A7 1 1 1
AD 1 1
AR 1

TableB BOX050 BOX060 BOX355
A3 1
A7 1
AD 1
AR 1 1

Using TableA as the base table, I would like to check if Table B matches
Table B and if not, where the mismatches a

I thought about setting up another TableC that hase the same row and column
headings as TableA, then find a formula for the body of the table that will
look at TableB and highlight the mismatches - sort of like this:

TableC BOX050 BOX060 BOX355
A3 Check
A7 Check Check
AD Check
AR Check

Can a formula do this ?

That said, is there a better way to compare Table A with Table B.

Thank You in advance.