Question posted 2011 · +11 upvotes
My question may seem quite simple but I haven’t found the answer yet.
In excel, I would like to access a cell with a dynamic row number.
Example 1 : cell A(1+2)
Example 2 : cell B(ROW(A1)*10)
What is the syntax for this ?
Thanks.
Accepted answer +20 upvotes
Use the INDIRECT function:
=INDIRECT("A" & (1+2))
=INDIRECT("B" & ROW(A1)*10)
Top excel Q&A (6)
- Shortcut to Apply a Formula to an Entire Column in Excel +335 (2011)
- How should I escape commas and speech marks in CSV files so they work in Excel? +136 (2012)
- Convert xlsx to csv in linux command line +96 (2012)
- How to create a link inside a cell using EPPlus +50 (2011)
- IF statement: how to leave cell blank if condition is false ("" does not work) +44 (2013)
- T-SQL: Export to new Excel file +44 (2012)
excel solutions on this site
— top 17%.