Need to merge data from two sheets with different structure according to 4 criteria

[Helal]

I need to merge data from two sheets with different structure according to 4 criteria. Criteria, attempt and desired outcome are outlined in the attached file. Appreciate any help.

Thank You,

Helal

[AL1976]

ESample.xlsxhi,
I did the attached but I don't have the same results as yours.
hope it helps in some way.
AL

[Helal]

Thank you...yes, there are some data mishaps (typos). But I didn't find your formula! it was all values (0,1).

[AL1976]

the formula is in column E, F and G of sheet A

[Helal]

sorry I didn't look carefully...got the formulas...thank you