How to find a LookUp value in 2 arrays and in certain columns?

[BittenApple]

Hello team,
I have find out the a lookup value and return some value from column 6:
This is my data:
Plan diagCode Num1
AA HBC 12
AA CDC 13

I have to look into both columns: Plan and Diagcode. What formula founds the value of Num1 for Plan AA and DiagCode HBC?

XLookUP? SumProduct? Index and match?

Please advise me.

Respectfully,
Tea

[HansV]

Unless you show what the sheet looks like it is impossible to answer.

[BittenApple]

I used this function:
INDEX(A1:G55,MATCH(1,(B:B=J2)*(C:C=J3),0),7)
I had two arrays:
Plan
measures
We wanted to look up values by looking up in this two arrays.
Regards,
VeryGreenTea.