Inputting an Array into an Offset equation

[Exceluser0105]

I am having trouble getting the below equation to work (Please note this equation is contained within an if statement):

GEOMEAN(OFFSET(Rates!$C$2,MATCH('Variable 1'!P9,Rates!$B$3:$B$300,0),MATCH('Variable 1'!N9,Rates!$D$2:$DB$2,0)

The Geomean formula normally requires an array with a ={geomean(array+1)-1} format. Without the array the geomean calculated is different.

How can I create the array formula in the above equation? Am I able to within the full equation as shown below?

=IF(S9="","",GEOMEAN(OFFSET(Rates!$C$2,MATCH('Variable 1'!P9,Rates!$B$3:$B$300,0),MATCH('Variable 1'!N9,Rates!$D$2:$DB$2,0),'Variable 1'!S9,1)))

 

[jasonb75]

Where is the array coming from? Your formula is only referring to a single cell.