Match key list and find missing

[seattlerose]

Ok, I have an issue and just can't think of the best way to figure it out.

I have a list with about 40K line items and I need to find what is missing for each Number group. In the below sample of my data you can see that the first number group on the Master tab is missing one from the Key tab based on Type, Prod & G/NG Combo. I need to know for each number group which if any are missing from the key tab for that Type, Prod & G/NG combo.

So logic is-

If Type, Prod & G/NG on Master Match on key there should be all the codes from the KEY Tab on the Master Tab. So below is a quick look at the data. As you can see one is missing from number group 440. I need a fast way to run through all 40K line items on the Master tab and have it tell me what is missing from each "number group". Thanks for any help.

Master Tab		Key Tab
Type	Number Group	Code	Prod	G/NG		Type	Prod	Code	Date	G/NG
AF	440	A66AN	S7	G		AF	S7	A66AN	6/21/2010	G
AF	440	A66EN	S7	G		AF	S7	A66EN	2/1/2011	G
AF	440	S70AAN	S7	G		AF	S7	S70AAN	1/1/2011	G
AF	440	S70ACN	S7	G		AF	S7	S70ACN	2/13/2012	G
AF	440	S70AEL	S7	G		AF	S7	S70AEL	2/25/2013	G
AF	440	S70AEN	S7	G		AF	S7	S70AEN	2/25/2013	G
AF	440	S70AFL	S7	G		AF	S7	S70AFL	2/25/2013	G
						AF	S7	S70AGN	9/23/2013	G

<tbody>
</tbody>