Forum Discussion
Solved
Get a value from a relative cell index
I search for an index and then I would like to get a value from the cell $xy + index
Is that possible ?
eg. When the research gives 2 as result, I would like to know the value from cell A1 +2, when 4 the result from cell A4 and so on
alice07620 If you mean to return the value from the cell 2 rows down from A1, you can use:
=OFFSET(A1,2,0)
You may replace the 2 by a cell reference that contains the number from "the research".
2 Replies
alice07620 If you mean to return the value from the cell 2 rows down from A1, you can use:
=OFFSET(A1,2,0)
You may replace the 2 by a cell reference that contains the number from "the research".
- Exactly !
Many thanks
