Matching multiple cell values

[NeedSomeSeriousHelp77]

Hi,

I have two spreadsheets.

The spreadsheets have the same information, the only difference is that one spreadsheet contains "previous months" records, while the other contains "new months" records.

I am attempting to find only the new entries in the "new months" records.

There are 11 fields, none are unique.

The second field, third field, fourth field and eighth field has to be perfectly matched between the two spreadsheets in order to ensure that the entry is the same.

For example;

Spreadsheet 1 (Previous Month)

A B C D E F G H I J K
X CAA 1 1234 X X X 39 X X X
X CA1 1 1234 X X X 39 X X X

Spreadsheet 2 (New Month)

A B C D E F G H I J K
X CAA 1 1234 X X X 39 X X X
X CA2 1 1234 X X X 39 X X X
X CA3 2 4567 X X X 49 X X X


The results from the comparison should do the following;

Compare column B1(new month) against column B1(old month). If true, then compare column C1(new month) against column C1(old month). If also true, then compare column D1(new month) against column D1(old month). If that's true as well, then compare column H1(new month) against column H1(old month). If all are true, then the result should be YES/TRUE/etc

If one of the values in the row of the "new month" does not completely match the values in the row of the "old month", then value should be NO/FALSE/etc, and this would indicate that this record does not exist in the "previous months" spreadsheet.

I want the results to show in either the "New Month" spreadsheet or a new spreadsheet.

Hopefully this is enough information for now.

Thank you!!!

 

[VoG]

Maybe this http://download.cnet.com/Excel-Overlay/3000-2077_4-10963782.html

 

[NeedSomeSeriousHelp77]

Hi, I appreciate the response on the download for Excel Overlay, but unfortunately I have a limitation where I cannot use any third party applications. I need to have it in a formula or VBA code...