efficient way to perform these matches

[Gareth Keenan]

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

[Shampoo Monkey]

Hey Gareth,

I think I have a clear idea of your setup... You have 5 categories, 4 of which are independant and 1 that is dependant on those other 4.

I am a bit unclear about what your trying to do though. Are you looking for records that are not in both worksheets?

[royUK]

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.