I want to use a cell Value as a named Range in a Formula

T

tmjones

I was a value in a cell to represent the name of a range that I want to use
in a formula. Is there a function or way to do this in excel without VBA?
 
K

Kevin Vaughn

This seemed to work though I don't know if it is necessarily the best way.
As a test, I put some numbers in a range (C4:C8) added a formula to sum it
(for comparison purposes,) highlighted the range and named it using the name
box (MyRange,) put the word MyRange in cell D4, made another formula =sum(d4)
which as I suspected returned 0 and then changed it so that it read
=sum(indirect(d4)) and it returned the same value as the previously created
sum formula for comparison purposes.
 
Top