One way:

=MIN(INDEX(INDIRECT("'Sheet1'!A:IV"),,COLUMN()))

So make In article
.com,
wrote:

Now, I am trying to drag the formula across IV cells using the + icon,
so that MIN(INDIRECT("'Sheet1'!A:A")) is for cell A1 and
MIN(INDIRECT("'Sheet1'!IV:IV")) is for cell IV1. The series is not
getting filled instead the formula is just copied. Anyway to fill the
series. Please let me know. Thanks