🚀 go-pugleaf

In article <BAECHLER.92Nov3155440@liasun6.epfl.ch>, baechler@lia.di.epfl.ch (Emmanuel Baechler) writes:
|> 
   [stuff deleted]
|> however be clearer for people who never used some of these languages: I need
|> a way to read and write cells whose address is the content of a given cell,
|> and which may be the result of a calculation.
|> 
|> I am already able to do this to READ a cell, with the functions
|> INDIRECT and ADDRESS. I however don't know how to select a cell whose
|> address is the content of a cell, in order to write in it. I have
|> tried several things, of the general form "SELECT(INDIRECT.."  or
|> "SELECT(CELL("content",<adr>.." and so on. None of them is however
|> working.  Without this tool, this application becomes useless because
|> almost everything has to be done at hand.

I think what you want to do is =SELECT(DEREF(reference))

-- 
 ----------------------------------------------------------------------------
 Tim Tow                              |                                      
 Intergraph Corporation               | "Injustice anywhere is a             
 Huntsville, AL                       |      threat to justice everywhere"    
 Mailpath:..timtow@timtow.b1.ingr.com |                                      
 Voice:                  205-730-2117 |         - Dr Martin Luther King, Jr
 ----------------------------------------------------------------------------