Intersection Value

Hi,

In the attached excel, format 1 sheet, I want to pull the value D6 as output. The condition I want to use is look for column "Type" and look "IP" and give the value whatever is under the column "Qty".

There is a possibility for this format to change. Look into format 2 sheet. An extra column FTT (Column B) is added. In this case also, I want the formula to work. (Output should be E6)

Is it possible?

If not, I just want the formula for format 1 sheet.

Can anyone help with this?

Thank you.