Variable range reference

K

Kyle Szukaitis

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.
 
D

Dave Peterson

=indirect()
???

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

if A1 contained something that looked like an address.
 
Top