Creating a double reference

[thsk]

Hi

I really hope to have some help with creating a sort of double reference.
I'd like to refer a cell in in another spreadsheet, but I like to fill out the cell number from a cell in the current spreadsheet.

Example:
The data I need is in =Spreadsheet2!$B$24
But I'd like to pick up the '24' from a cell in the current spreadsheet
Illustrated but not working:
=Spreadsheet2!B(=Spreadsheet1!B2)

How can you do this?

thanks in advance
thsk

 

[Giordano Bruno]

Suppose that "24" is in A1.

=INDIRECT("Spreadsheet2!B"&A1)

 

[thsk]

Thanks alot Bruno! That worked as magic!

thsk