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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Changing relative cell reference 2
Can I sort and not lose reference to the cell? 3
Formula with Cell reference to include formating? 13
Referencing a tab in a formula 2
how do i use the text in a cell as a named range in a vlookup form 2
Continuous Invoice Nos. 3
Impacting a cell 4
Help needed with cell reference 6

Top