Sorry for late in rely XLD, please find attached file for more information.
For case 1: I have to use a lot of sumproduct function, and I looking for another alternative function.

For case 2: I looking for a multi-criteria lookup function.

Hope it is clear