using a named cell in a fuction

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?
 
F

Frank Kabel

Hi
use INDIRECT for this if I understood you corectly. So try
=CORREL(INDIRECT(B1),INDIRECT(A3))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Function to Move Correl over one column at a time 7
Using range names in functions 2
Cell Value as Named Range Reference 1
relative offset to a named cell 3
Problem with INDIRECT arguments in the CORREL function 1
Comparison of columns using Conditional Formatting 3
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
calculating a value if adjacent cell has value 3

Top