using a named cell in a fuction

  • Thread starter Thread starter Josh
  • Start date Start date
J

Josh

I have a table with 10 columns and rows. Each column and
row has a different title that matches an array of cells.
I'm trying to make a correlation matrix =correl
(array1,array2)

i want to make the function so that it takes the
correlation of the arrays matching its column and row,
meaning that cell b3 would =correl(b1,a3) where in both
b1 and a3, there would be a text entry with a name equal
to that of a named array on another sheet. My question is
how can i have the formula interpret the names in the
column and row headers as names and not text?
 
Hi
use INDIRECT for this if I understood you corectly. So try
=CORREL(INDIRECT(B1),INDIRECT(A3))
 
Back
Top