Use a value as a cell reference

R

Rachel

I want to be able to use a number in a cell as a row reference in a formula.
For example, suppose a1=95, a2=149. I want to be able to create a formula
equivalent to "=max(d95:d149)" using the values in a1 and a2 to define the
range.
Thanks for your help
 
N

Niek Otten

=MAX(INDIRECT("D"&A1&":D"&A2))

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|I want to be able to use a number in a cell as a row reference in a formula.
| For example, suppose a1=95, a2=149. I want to be able to create a formula
| equivalent to "=max(d95:d149)" using the values in a1 and a2 to define the
| range.
| Thanks for your help
 
Top