How to find the formula inside #REF error

[#REF error]

Hi ,
I have a formula which is refering to a another sheet as follows

=SUMIF('Sheet1'!G:G,A2,'Sheet1'!#REF!)

I want to know what is the formula written inside the #REF!

Is there any way I can find the formula inside the #REF

Thanks
MKJ

 

[Dave Peterson]

The #Ref! error means that the range that the formula referred to has been
deleted.

I'd bet it used to point at a column that was deleted. Can you go back to a
previous version to see?

 

[#REF error]

Hi Dave,

Thank you for your quick reply. But I want to know what are the referenced
rows which were deleted or moved.

 

[Dave Peterson]

Take a look at the previous version if you still have it.

If you don't, then you're out of luck. Excel doesn't keep track columns that
you delete.

 

[#REF error]

Hi Dave,

My bad luck,I don't have a previous version of it.

Regards,

MKJ

 

[Dave Peterson]

Maybe you could look at headings to see what kind of data was being brought
back. If the header says "Customer ID", then look at the "sending" sheet and
see if there's still a column marked "customer id" (or close to it).

Hi Dave,

My bad luck,I don't have a previous version of it.

Regards,

MKJ