|I am trying to find a way to use a number from a cell to help specify a cell address.|
Example: I have a cell with a number in it, let's call this number x. Now I want to get another number from a cell with the address <Sheet2!Ax>, is this possible?
I've tried different methods with INDIRECT, but it didn't help.
Example 2: Say I want the SUM from cell A1 to cell Ax, where x is a number in another cell that can change independently. Can you write =SUM(A1:A"Sheet2C3") or something similar?