Adding criteria to array reference

Hi

I'm doing some production volume calculations in the format of a table, which has products as line items (rows), and years across the top (columns). These volumes change each year according to a "Type curve", of which there are several different ones. I have all these type curves laid out in a "TypeCurve" tab, and need to reference them into my main calculation tab where I have several other operations to perform on them, such as some cumulative production calcs.

My question is - how to 'choose' the correct typecurve row to call from that tab into my sheet? There are three criteria by which the typecurves vary. I would normally use SUMIFS and add in three criteria, however the issue is that SUMIFS can't handle changing sizes of arrays. I've chopped out a piece of one of my equations to show an example of what I'm trying to do.

SUM(TypeCurve!$I$32:I$32)

As you can see, this is a cumulative calc which, when autofilled across a row in my calculation sheet, will reference a continuously growing array in the typecurve sheet. How do I get my equation to reference the correct row according to certain criteria?

Cheers

That works well - for a single criterion. Unfortunately I have three. I've included sample data below, apologies if it looks a little weird. I need to be able to choose the correct row according to TypeCurve, Length, and Product Type. Is it possible to 'stack' INDEX/MATCH functions or is there some other way?

Please Login or Register  to view this content.

That seemed to do the trick, thanks!