Darrell Hipkiss
New Member
- Joined
- May 9, 2016
- Messages
- 10
Hi everyone,
I need assistance with a formula I am trying to develop using OFFSET and MATCH.
The attached workbook contains two tabs: PIPELINE & DATA.
The DATA tab will contain my raw data calculations.
The PIPELINE tab will be a read only tab, with the exception of column C (starting C11) which is where I want the formula (reading from DATA tab (column E), depending on the Division (column D).
What I want my formula to achieve: I Want Excel to return each successive GCHHS number (moving down) only if it matches the Division on the PIPELINE tab.
This will need to be a repeatable formula that starts from each new Division on the PIPELINE.
The report will be run monthly and the number of rows may change per Division, so I suspect I will need to manually repeat the formula on the applicable rows in the PIPELINE tab.
I have attached a screen shot but also can attach the file (but wasn't sure how to)
I need assistance with a formula I am trying to develop using OFFSET and MATCH.
The attached workbook contains two tabs: PIPELINE & DATA.
The DATA tab will contain my raw data calculations.
The PIPELINE tab will be a read only tab, with the exception of column C (starting C11) which is where I want the formula (reading from DATA tab (column E), depending on the Division (column D).
What I want my formula to achieve: I Want Excel to return each successive GCHHS number (moving down) only if it matches the Division on the PIPELINE tab.
This will need to be a repeatable formula that starts from each new Division on the PIPELINE.
The report will be run monthly and the number of rows may change per Division, so I suspect I will need to manually repeat the formula on the applicable rows in the PIPELINE tab.
I have attached a screen shot but also can attach the file (but wasn't sure how to)