Calculate row/column number in reference formula

M

mirin

Hello,

I have the below formula in a cell:
=Sheet1!A19

Now instead of 19 I want to calculate the value 19 like (current row
number -1) but obviously putting the formula as =Sheet1!A(Row()-1)
doesn't work. How can I set it as a calculated value?

Thanks!
 
G

Glenn

mirin said:
Hello,

I have the below formula in a cell:
=Sheet1!A19

Now instead of 19 I want to calculate the value 19 like (current row
number -1) but obviously putting the formula as =Sheet1!A(Row()-1)
doesn't work. How can I set it as a calculated value?

Thanks!
Click to expand...

=INDIRECT("Sheet1!A"&ROW()-1))
 

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

Need Help with a VBA subroutine 0
Copy addition formula of non-consecutive horizontal cells 2
Macro to change referenced column to the next one 1
Remove Identical words 0
Display weeks from a Milestone 0
Row reference for consecutive series calculation 0
Referencing cells in consecutive rows 2
reference every 19 rows 8

Top