ExcelBanter - Use a value as a cell reference

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Use a value as a cell reference (https://www.excelbanter.com/excel-discussion-misc-queries/191283-use-value-cell-reference.html)

Rachel

Use a value as a cell reference

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

Niek Otten

Use a value as a cell reference

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Rachel" wrote in message ...
|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

All times are GMT +1. The time now is 07:17 AM.