=IF(ISBLANK(A2);"";
    IF(A2="Not Available";"";
        IF(AND(A2="TypeA";B2=1,1);"ANModel1";
        IF(AND(A2="TypeA";B2=1,5);"ANModel2";
        IF(AND(A2="TypeA";B2=2,2);"ANModel3";
        IF(AND(A2="TypeA";B2=3);"ANModel4";
        IF(AND(A2="TypeA";B2=4);"ANModel5";
        IF(AND(A2="TypeB";B2=0,55);"FNModel1";
        IF(AND(A2="TypeB";B2=0,75);"FNModel2";
        IF(AND(A2="TypeB";B2=1,1);"FNModel3";
        IF(AND(A2="TypeB";B2=1,5);"FNModel4";
        IF(AND(A2="TypeB";B2=2,2);"FNModel5";""))))))))))))

Type    Power   Part
TypeA   1,1     ANModel1
TypeA   1,5     ANModel2
TypeA   2,2     ANModel3
TypeA   3       ANModel4
TypeA   4       ANModel5
TypeB   0,55    FNModel1
TypeB   0,75    FNModel2
TypeB   1,1     FNModel3
TypeB   1,5     FNModel4
TypeB   2,2     FNModel5

{=INDEX(Data!$A$2:Data!$C$11;VERGELIJKEN(1;(Data!$A$2:Data!$A$11=A2)*(Data!$B$2:Data!$B$11=B2);0);3)}