Cell value based on three references cells

[ChrisNor]

Hi,

I have a 3 dimmensional array... I think that is what you call it.. Anyway See the attached file for an examples.

The first sheets contains data of certain years. Static data, manually inputted.

The second sheet uses the CAGR function to calculate the Compunded Annual Growth Rate between the years with data.

The third sheet, then uses the CAGR Calculated in the Second sheet, to calculate each years value based on the First sheet.

My problem is that each cell has three values to relate to.

Reference numbers/dates: Year, Area, Type.

So the Second Sheet "Process Sheet", needs to find the columns with data. and calculate the CAGR for the period in between those years.

So cell B7 needs to look to Column A (A7) to find the years "1990-2006", first year 1990 and second year 2006. It then needs to use the ref id for "Area" B3, and B5 for the ref id for "Type".

This data, needs to be implemented into the =CAGR(16;;0-'Input data sheet'!B6;'Input data sheet'!B22) formula.

Cause at the moment it is all static, so I need to make the formula dependet on the headers / reference columns.

Hope someone can help!