Using INDIRECT function with an array formula

Hello,
I have a stream of monthly stock returns in a column (Column B) in a sheet called "Performance". I am trying to get the cumulative return for the period specified. Normally, if the range was fixed, I would use the product formula, in this case "{=product(1+Performance!B6:B102)-1}. But I am using a match function to determine the range. I have determined the beginning row in cell "C1" and the ending row in cell "C2", using the match function. I am trying to use the INDIRECT function within the PRODUCT function to get my result. It doesn't seem to be working. Here is my best shot at it:

{=PRODUCT(1+INDIRECT("Performance!R"&$C$1&"C2:R"&$C$2&"C2",FALSE))-1}

I also tried:

{=PRODUCT(INDIRECT("1+Performance!R"&$C$1&"C2:R"&$C$2&"C2",FALSE))-1}

Any help would be greatly appreciated.

Thanks!

Yes, that did it! I guess you can't use the RC format, which is weird since I have been using it in other formulas. I guess just not arrays.

Thanks for your help.

Oh, right. I need to put the reference in RC format too. Thanks for the help!

Actually the formula you posted in the RC format didn't work. Ideally I would like it in RC if possible.

Somehow, my original formula now works. Very weird.