Variable range reference
 

How do I use the value of a cell as a reference to a range?

I have a cell value that is assigned by a series of IF statements. I would
like to use the value of this cell within a INDEX and MATCH function to
define the range.

Variable range reference
 

=indirect()
???

=index(indirect(a1), ....)

if A1 contained something that looked like an address.

Kyle Szukaitis wrote:

How do I use the value of a cell as a reference to a range?

I have a cell value that is assigned by a series of IF statements. I would
like to use the value of this cell within a INDEX and MATCH function to
define the range.

--

Dave Peterson