@NBVC: Sorry for my slow response, my work network seems to keep going down and can't access outside websites.

But, I just read your last post and realized I probably wasn't clear. The "Type" is in the data table and has no correlation to the lookup table. It would be just a "normal" SUMPRODUCT array function.

By normal, I mean (ignoring my lookup issue), the formula would be:
=SUMPRODUCT((F2:F6)="TypeA")*E2:E6)

My problem is I need to do the above filter together with the lookup function you provided. I can't quite figure out how to combine them.

Thanks again for your help,
JC