Excel - Dragging problem in Indirect Function

December 2016




Issue


I have only data in Sheet1 from C2 to C200 and

I am using Indirect function in Sheet2 and when i drag it from C2 to C200 it is showing

only C:2 data in all cell from C2 to C200



=INDIRECT("'Sheet1'!C2") 



I am not able to sort out this problem please help me

Solution


You can try this:

=INDIRECT("'Sheet1'!C"&ROW(C2))

Note


Thanks to rizvisa1 for this tip on the forum.

Related :

This document entitled « Excel - Dragging problem in Indirect Function » from CCM (ccm.net) is made available under the Creative Commons license. You can copy, modify copies of this page, under the conditions stipulated by the license, as this note appears clearly.