Using Indirect() with Transpose()
I'm trying to use Indirect inside a Transpose function and I'm getting a parsing error.
=TRANSPOSE('570 1 questions'!INDIRECT(I2))
I'm trying to reference the I2 cell which has a range in it (E12:E16). I want to transpose the data from that range in another sheet.
Is this possible?
Posted Apr 9, 2025, 8:32 PM UTC
11