Check if a Field is used in an other field for a Formula?

[Fabsi 91]

Hello

(Sry for my englisch!)

Does anybody know how to find out if one field (expl. A1) is used in an other field (expl. F13) for a Formula???

Example: A1 is used in F13 (Sheet 1) (Formula in F13: (=Sheet3!A13 - Sheet5!A1)) But in an other sheet or Excel file

- so now we can see the Formula in F13,

BUT HOW CAN YOU CHECK IF A1 IS NEEDED For Formula (F13) WITHOUT CHECKING F13??? Also in other sheets or Excel files???

Is this possible???

Thanks Forward enjoy your day!!

[Tony Valko]

Excel 2013 has a new function called FORMULATEXT( ) that returns the formula from a reference as a text string.

A1 contains the formula: =Sheet2!X1

=FORMULATEXT(A1)

Returns the text string: =Sheet2!X1

Then, if you want know if that formula contains a cell reference to cell X1:

=ISNUMBER(FIND("X1",FORMULATEXT(A1)))

[Tony Valko]

Another possibility...

=RIGHT(FORMULATEXT(A1),2)="X1"