Highlight missing entries and reclassify

Hi All
I have database with raw data and a summary sheet (entitled “m2”) which uses the following formula:

Please Login or Register  to view this content.

My problem is that I need to identify items on the “Sales” sheet which do not appear on the M2 sheet. This formula looks at both Column H and Row 3 and matches this with AW on the “sales” tab.

I need help with...

1. A way I can highlight to see what the missing entries are (then I can make a decision on whether to include them on the M2 sheet)
2. For a formula which basically says if it doesn’t appear on the M2 tab classify it as “Other” (which it would then make it appear on the m2 sheet as this is a product category, cell H337).

Anyone know a way to do this?

I have attached a sample file - it is quite large and very slow so if anyone knows of a way to speed this up please say.

Hi

Anyone have any suggestions at all?