Hi there,

I'm trying to refer to the row number of a remote table, using the current column number shifted by one.

Remote Table:
#+NAME: my-table
| Header1 | Header2 |
|---------+---------|
|   a     |    23 |
|   b     |    7    |
|   c     |    13 |
|   d     |    66 |
|   e     |    5    |
|---------+---------|
| Result | 42 |

Table where remote value should be inserted:
...

#+TBLFM: @1$3..@1$7= remote(my-table,@$#$2)

My problem is, that this remote reference starts in row 3 (because of @$#), however, I'd like to start in row 2 (that means @$#-1). However, this relative reference does not seem to work here.

Any idea what command I can use here?

Thanks!

Best, Volker