Excel - Dragging problem in Indirect Function

February 2017




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


Published by aakai1056. Latest update on April 23, 2010 at 09:30 AM by aakai1056.
This document, titled "Excel - Dragging problem in Indirect Function," is available under the Creative Commons license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM (ccm.net).