Excel Formula to compare multiple columns

Hello Again,

Need help in comparing multiple columns and get the result as showing the attachment.

Excel formula need to check the following:-

- If the column D values is matching column I. In case of not matching the result in column N will not Description is Not Matching.
- If the column E values is matching column L. In case of not matching the result in column N will not Type is Not Matching.
- If the column E values is matching column L. In case of not matching the result in column N will not Type is Not Matching.
- IF all the columns are not matching then the result will be in column N Description is Not Matching, Type is Not Matching, Date is Not Matching, Amount is Not Matching.
- If all the columns are matching the result will be in column N is Correct

Copy of expecting output result is attached for your reference.

Thanks to both of you.

I got an idea hot it works.

But 1 question. How can i manage if the columns D, E, F & G are blanks or if columns H, I, K, L & M.

Because it is possible that previous items is not exist on current list or current list don't have any previous records.

In this case the result will be blank. can it be possible.

I will try but incase if I fail.

This is good out the sites.

You can expand your skills but experts helps.

I did not expect this kind of professional possibilities.

Thanks you very much to all of you. let me give a try if not i will get back to you.

Topic mark to be closed.