Excel - Dragging problem in Indirect Function

April 2018




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.
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 (https://ccm.net/).
Excel - Search & Display query
Excel - How to sort and delete redundant value?