Convert 123 @@(@COORD()) to excel?

[Tim Ackers]

Hi all

Problem:
Converting the @@(@COORD()) function from Lotus 123 for
Smartsuite 97 into MS Excel for Office 97.

There is a similar function in Excel: =INDIRECT(ADDRESS())

But by itself this does not seem to be as powerful as the Lotus
equivalent @@(@COORD()), as the Lotus function enables you to
enter the sheet as a variable that can be addressed either
relatively or absolutely.

So, is there a work-around in Excel, that perhaps uses some
combination of ADDRESS() and other functions that would answer
the instruction:

"Give me the content of cell {row, column} in the n'th worksheet
of the workbook"?

Thanks
Tim Ackers
tim_a...@compuserve.com

--

[Jim Rech]

Generally sheet references are absolute in Excel but you might be able to
get most of what you want with a formula like this:

=INDIRECT(ADDRESS(2,3,,,INDEX(Sheets,3)))

You must create the name Sheets using Ctrl-F3. Give it the definition of
=GET.WORKBOOK(1)

The above formula would return the value of cell C2 on worksheet 3.

--
Jim Rech
Excel MVP