Re position ranges based on criteria (group number and date)

[Jackson2806]

Hi all,

I am trying solve what I though was a straightforward problem.... hoping someone out there in the community knows this.

In Sheet 1, I have production data by group that is normalised back to day 0. i.e. all groups' production rate start from the same day 0.

In Sheet 2, I have rows by date and columns that represent different wells which are associated with a group (row 2) and also a first date of production (row 4). These are my two criteria (group and first date).

What am I trying to achieve? Using "Downer_1" well in sheet two as an example, it is in group 1 and a first production date of 24/11/2018. Therefore, I would like to take the corresponding data from Sheet one in Column B, and output in Sheet 2 starting at the date 24/11/2018.

I would then like to do this for every well in Sheet 2's output cells. Basically a case choosing which data is appropriate for the well column based on which group it is in, then shifting this data vertically based on the date of first production.

Please let me know if I am not being clear enough.

Thank you in advance!

Jackson

[Gregb11]

Try this in cell C8, and the copy down and across:
=IF(C$4>$B8,"",INDEX(OFFSET('Sheet 1'!$B$3:$B$481,0,MATCH(C$2,'Sheet 1'!$B$2:$H$2,0)-1),MATCH($B8-C$4,'Sheet 1'!$A$3:$A$481,0)))

File attached.

[Jackson2806]

GregB11.... excellent! Thanking you very much - this does exactly what I need on a much larger scale.

[Gregb11]

You're welcome. Glad it worked.