I have data on two spreadsheets that I need to reconcile, and would like to set up a formula to have excel quickly faciliate the matching.

Ideally something along the lines of IF( lots of matching stuff, 0, 1) Then, when I've automated my formula and spread it across the range I need to match values and have selected all of my cells, then I can use that little window in the bottom which sums all of the selected cells and if I see a sum of zero I'm in the clear and if not I can find those rascally 1s.

here's an example. Let's assume I have these categories

House_type
House_color
house_zip
House_square_footage

Please note that all of these categories are not binary, they can take one of a few values, but more than two.

For each combination of those 4 categories(the four independant variables) I have one dependant variable, let's call it pure_premium. In both spreadsheets, there is a unique pure_premium variable for all combinations of the four independant variables.

The heirarchies of the four categories are different on both spreadsheets.

Is there an excel function that I can use that can help me with this, perhaps even embed the function multiple times in the same formula.

Kind Regards,

Gareth Keenan