Lets say cell A4 + 4 wil go to cell A8
What’s the question here?
- Do you want to move four columns to the right (press right arrow four times)?
- Do you want to move directly to a specific cell (type
A8into “Name Box” and pressENTER)? - Do you need the value of the cell 4 columns right of
A4(INDEX(),OFFSET()) ? - Do you want to perform a calculation
A4+4and show the result in cellA8(formula=A4+4into cellA8)?
The author’s definition of go to might be needed here…
I just want to move from A4 4 cells down to A8 and the read (indirect) what there is. Thus A4 <plus 4> reads what is in A8
That’s not a “go to”, but a “get from”. The cell to get from is defined by its offsets (Row; Column) relative to the cell referenced by the first argument of OFFSET() as @erAck exemplified based on your example.
The offsets for rows and/or columns may be negative.
Thanks, exactly what I needed.
Glad to help. Then please mark the answer as correct by clicking the check mark icon. Thanks.
erAck, I would if I could see where. Must have the wrong glasses on 