get text form cell

[kimizito]

Hi,

I have this offset function working:
=OFFSET(calculos.xlsx!_5260;10;5)

The cell name "5260", is also entered as text in cell A1, in the current workbook (not calculos.xlsx). How do I refer excel to get the text from cell A1, instead of having to enter it manually.

Thanks,
Pedro

 

[Joe4]

Welcome the Board!

Try:
=OFFSET(INDIRECT("calculos.xlsx!_" & A1;10;5)

 

[kimizito]

Worked! (You just missed the ")" after A1

=OFFSET(INDIRECT("calculos.xlsx!_" & A1);10;5)

Thanks.

 

[Joe4]

Whoops! Sorry about the typo. Glad you figured it out.
You can use the INDIRECT function anytime you are calculating a range reference on the fly.