Cell Value as Named Range Reference

[stephen.h.dow]

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.

 

[Wigi]

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