I am trying to lookup values from another sheet using the following formula:

=INDEX('Sheet2'!C1:C30,MATCH(1,IF('Sheet2'!D1:D30='Sheet1'!B1,IF('Sheet2'!E1:E30>'Sheet1'!F1,IF('Sheet2'!H1:H30>'Sheet1'!G1,1))),0))

It works fine but I would like to have the H1:H30 column of sheet 2 between Sheet1 G1 and Sheet1 G1+6. So more than sheet1 G1 date but less than Sheet1 G1+6months.

It is a little confusing but any help would be great.

Let me know if further clarification is needed.

Cheers.