Index, Match, left and middle equations

[zeez36]

Dear all,

I have a products in 2 warehouses.
Column A has the products ID.
Column B available quantities in warehouse 1.
Column C available quantities in warehouse 2.

I need equation to get the quantities for each WH and add them in the table in the right side.

That table split to be row 5 is the left side of the products in column A
Row 6 is middle of the products in column A
Column F is middle of the products in column A

[Bo_Ry]

Please try at G7

=IFERROR(1/(1/VLOOKUP(G$5&G$6&$F7&"*",$A$2:$C$37,MATCH($K$3,$A$1:$C$1,),0)),"")

[zeez36]

Working perfectly

Thanks a lot