增量单元格引用10

I am referencing a cell on another sheet the reference is the following in the B2 spot.

我正在引用另一个表上的单元格，该引用在B2点以下。

=Data!B227

I would like to drag down so B3 becomes =Data!B237 how can I go about accomplishing this?

我想把B3变成=数据!我怎样才能着手去完成这件事呢?

1 个解决方案

#1

In B2:

B2:

=INDEX(Data!B:B,227+((ROW(1:1)-1)*10))

Then drag/copy down

然后拖动/复制下来