Setting the cell number as a variable
Let's say your variable number is located in cell A1, and you want to
reference somewhere in column B. Use this formula:
=INDIRECT("A"&A1)
You can see the help file for further details, if you need them.
--
Best Regards,
Luke M
*Remember to click "yes" if this post helped you!*
"Intern" wrote:
Is there a way to set the number of a cell (A5) as a variable (A(variable))
so that I would be able to select different cells in column A by changing the
variable?
|