Index + offset

[Forestq]

Hi,

I had formula:

= INDEX($E$24:$AK$24,1,$E$8)

How can I here add offset, that function will return value number from row 25 ? (now its value from row = 24, but I need value from row = 25).

 

[Andrew Poulsom]

You can't return the value of a cell outside the referenced range. So you would need one of:

=INDEX($E$25:$AK$25,1,$E$8)

=INDEX($E$24:$AK$25,2,$E$8)

 

[Forestq]

perfect,
thanks Andrew!