drag and drop problem with cell references

N

natanz

i have a cell with a formula in one worksheet that references another
cell. the formula looks like this:
=IF((ISBLANK('Draft'!$D25)),"",'Draft'!$D25)
where 'draft' is another worksheet in my workbook.
the formula works fine, it looks empty if there is nothing in the
referenced cell('Draft'!$D25), otherwise it mirrors the content of that
cell. If i type something in the referenced cell('Draft'!$D25), it
still works great. But if i drag something to the referenced cell than
the formula gets screwed up and replaces the $D25, with #ref.

I am guessing that there is probably a good reason for this behavior,
but is there a way to work around it, so that the contents of the
referenced cell show in the referencing cell, regardless of whether
they were typed or dragged.

thanks in advance for your help.
 
B

Biff

Hi!

Try this:

=IF(INDIRECT("Draft!D25")="","",INDIRECT("Draft!D25"))

Drag and drop to your hearts content!

Biff
 
M

Mangesh Yadav

Use:

=IF((ISBLANK(INDIRECT("draft!D25"))),"",INDIRECT("draft!D25"))

Mangesh
 
Top