即使它在引号中，如何使单元格的坐标变量？-Howtomakethecoordinatesofcellvariableevenifitisinquotes?

The formula im using is =INDIRECT($A$1&"!D1"), which is just giving me data from a sheet whose name is is A1!. However, I don't just want whats in D1, i want D2,D3,D4..etc. But when i drag the box down, it the number after the D stays constant. Is there a way i can make it variable? Thanks

我使用的公式是= INDIRECT($ A $ 1&“!D1”),它只是从一张名为A1!的工作表中提供数据。但是,我不仅仅想要D1中的什么,我想要D2,D3,D4 ......等等。但是当我向下拖动框时,D后面的数字保持不变。有没有办法让它变量?谢谢

1 个解决方案

=INDIRECT($A$1&"!D" & ROWS($1:1))