jgedwardsv
New Member
- Joined
- Oct 27, 2016
- Messages
- 31
Hi all -
I'm trying to write a formula that will correlate two columns of data (they are equal size). I'm having trouble figuring out how to make my lookup return all the values from the column I identify (right now it only returns 1).
Here is the formula I've used:
=CORREL(TDFAnalysis[AverageEquity],INDEX(TDFAnalysis,{1,2,3,4,5,6,7,8,9,10,11,12,13,14},MATCH(TEXT([@[Fund Series]],"@"),TDFAnalysis[#Headers],0)))
{1,2,3,4,5,6,7,8,9,10,11,12,13,14} are the columns I need to return and I believe that is where the formula is breaking.
Thanks!
I'm trying to write a formula that will correlate two columns of data (they are equal size). I'm having trouble figuring out how to make my lookup return all the values from the column I identify (right now it only returns 1).
Here is the formula I've used:
=CORREL(TDFAnalysis[AverageEquity],INDEX(TDFAnalysis,{1,2,3,4,5,6,7,8,9,10,11,12,13,14},MATCH(TEXT([@[Fund Series]],"@"),TDFAnalysis[#Headers],0)))
{1,2,3,4,5,6,7,8,9,10,11,12,13,14} are the columns I need to return and I believe that is where the formula is breaking.
Thanks!