Match/Index Functions - Matching rows according to criteria..maybe macro?

Here is the setup of the excel spreadsheet:

Product #
Store #
Under 45
Over 60

These would be in columns A, B, C, & D.

Column A might have 5 rows corresponding to a specific Product # but with different store codes.

I need a lookup/macro to find specific product codes that are the same according to specific criteria in columns C & D.

For example

1111, 23, 0, 10
1111, 24, 10, 0

In this case, the product code is 1111. Store number 23 has 10 "Over 60" and Store number 24 has 10 "Under 45".

My criteria for matching are in columns C & D...since the first store has 10 in the D column, and second store has 10 in the C column, they would match up.

I need this information highlighted in a particular color or returned on a different sheet.

Possible?

Thanks for any advice.

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!

I've attached a dummy workbook as requested. In this case, two rows are highlighted (Row 7 & 8).

They have the same product # and match the criteria of having 10 "over" in store #233 and 10 "under" in store #333.

I'm trying to match up excess inventory in one store with a shortage of inventory in the other store for each product code.

The matches can be highlighted or even spit out as results in another workbook but I need all matches flagged.

Hope this clears up some confusion.