I’m trying to find a formula but let me explain first that:
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.