Little bit of a quirky question...

Trying to use a cell value as a reference in a formula, where that
cell value is the name of a named range.

So, assume A1:A3 is a named range: Rng1. And, B1:B3 is Rng2.

I want to get the correlation vale for A1:A3 and B1:B3

So, cell D1 contains "Rng1" and D2 has "Rng2"; and cell D3 has the
formula: =correl(D1,D2). But I get an error. Have also tried using
Indirect to no avail.

Any help would be hugely appreciated. Thank you.

=CORREL(INDIRECT(D1),INDIRECT(D2))

--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"(E-Mail Removed)" wrote:

> Little bit of a quirky question...
>
> Trying to use a cell value as a reference in a formula, where that
> cell value is the name of a named range.
>
> So, assume A1:A3 is a named range: Rng1. And, B1:B3 is Rng2.
>
> I want to get the correlation vale for A1:A3 and B1:B3
>
> So, cell D1 contains "Rng1" and D2 has "Rng2"; and cell D3 has the
> formula: =correl(D1,D2). But I get an error. Have also tried using
> Indirect to no avail.
>
> Any help would be hugely appreciated. Thank you.
>