Get a value from a relative cell index

[alice07620]

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

[#2 · Accepted solution]

@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".

[#3]

Exactly !
Many thanks