Comparing Values by Rows

Newbie question here:

I have account numbers in col A in 2 stacked rows. The account numbers are identical. I'm trying to write a formula that will check the values in col C and write something to col D when the values in col C (associated with the matching values in Col A) do not match. Here's my simplistic logical statement:

If the values in vertically adjacent rows in column A match, then check the vertically adjacent values in the same 2 rows in column C. If the second set of values do not match, return the statement FALSE in column D.

Put more plainly, we are trying to verify the status of accounts in two seperate inventories.

Hope this makes sense. Thanks in advance for any help,

AKeene

I'm not positive on your request, but try this formula in D2:

=IF(AND(A2=A1,C2=C1),"")