Cell Referencing

[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 or something
similar?

With thanks
Bruce

 

[Dries]

Hi Bruce,

use the formula =column(Sheet1!D2);

Br,
Dries.