Excel excel extract cell link definition & use it as variable

[pumasdaniel]

If in A1 (blank excel file) I have a link as result of a manual operation (writing =, going to price list excel file, select a cell and then press enter, then going back to the original blank excel file) as result I have '[price list.xls]book1''!$A$4, this formula is shown at the fx small window. The link formula bring the value 'banana'

A1
banana
fx = '[price list.xls]book1''!$A$4

B1
4
fx = row (C1)


C1
'[price list.xls]book1''!$A$4

fx= ??????? using A1



now I use and other cell B1 to calculate the row of '[price list.xls]book1''!$A$4, as follows: =row('[price list.xls]book1''!$A$4) giving me 4.

The problem is that every time I change the link in A1 I have to rewrite the formula in B1.

Is there a way to extract the link formula from A1 --> '[price list.xls]book1''!$A$4, put it in a cell C1l and used it as data variable, so in B1 I’ll have something like = row (variable)?, which variable content is '[price list.xls]book1''!$A$4, in this way does not matter how many time I change the link in A1, B1 always will show the value of the row of A1 contents.

Thankshttp://http://