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, w...
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".
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
Many thanks