Some assistance with indirect / Offset gratefully received!!

[stevedhawes]

Hi all,

Hoping someone can help here.

I need to reference cell values on an other sheet and on researching it seems like "Indirect" was the most suitable function to use.

I have managed to get this working as per below:-

=INDIRECT("'Sheet2'!N"&ROW(N4))

I can copy this down all the rows i need no probs, but it wont let me copy the formula across columns, using the the above example i would see the formula

=INDIRECT("'Sheet1'!N"&ROW(O4))

It seems as though i need to use Offset function in conjunction with this, but just cant figure out how to do it, so thought id ask the experts!!

If anyone is able to send me back the correct formula example id be incredibly grateful. Many Thanks

 

[Aladin Akyurek]

Try...

=INDIRECT("'Sheet2'!"&CELL("address",N4))

 

[stevedhawes]

Aladin, thats amassing!!

Thank-you so much - worked perfectly, i spent hrs trying to suss out that one!!

Kind regards
Steve

 

[Aladin Akyurek]

Aladin, thats amassing!!

Thank-you so much - worked perfectly, i spent hrs trying to suss out that one!!

Kind regards
Steve

You are welcome.