B
Bruce
Hello All,
If I have an excel spreadsheet open with two sheets. In
Sheet1 in cell D2 is "Hello". In Sheet2 in cell F4 is
the formula "=Sheet1!D2", so it also says "Hello".
What I want is to have next to F4 in Sheet2 (in cell E4)
a reference to which row in Sheet1 that the formula in F4
is referring to?
Ie. Cell E4 should have the number 2 in it.
Is this possible using the =INDIRECT function and the =ROW
formaula in combination?
With thanks
Bruce
If I have an excel spreadsheet open with two sheets. In
Sheet1 in cell D2 is "Hello". In Sheet2 in cell F4 is
the formula "=Sheet1!D2", so it also says "Hello".
What I want is to have next to F4 in Sheet2 (in cell E4)
a reference to which row in Sheet1 that the formula in F4
is referring to?
Ie. Cell E4 should have the number 2 in it.
Is this possible using the =INDIRECT function and the =ROW
formaula in combination?
With thanks
Bruce
,0)