Lookup with Multiple criteria

I am having troubles getting my formulas correct in reference to looking up multiple criteria.
I have got to this stage whereby I will give an example and hope the smart people can show me the formula.
As per the attached sample, I would like to match up Columns A, B,C and F from sheet2 with columns a,b,c and d in Sheet1.
Once the formula finds a match I would like the value in Column E of Sheet 1 to be placed in Sheet 2's Column G.
Could someone please help me solve this query. Thank you in advance for any support you can offer.