=cell result!a1

Hi!

 

I’m trying to find a formula but let me explain first that:

e.g. 

A10 cell has got this formula: =xe!a1 where it comes with the correct result (XE is the sheet name and A1 is the cell from the XE sheet that i want to mention on A10 cell. 

C10 cell has got this formule: =xe!b1 which comes to different result.

What i want now is to find a way to “replace” the xe from C10 cell to “a10” 

I hope that it is clear that i want to have c10 cell =”result of a10″!b1

when i do =A10!b1 i get wrong result.

By: Lemonia

Leave a Reply

Your email address will not be published. Required fields are marked *