Here is the break-down:

Criteria (text) in A:A and criteria (text) in B:B needs C:C to contain at least all text provided by A:A and B:B. I then need to average all of the cells in C:C which met the criteria aforementioned by using the values provided in D:D.

Please advise.

Thanks!