Re: Referencing ceils on other page
- From: Oliver Burnett-Hall <olly burnett-hall co uk>
- To: gnumeric-list gnome org
- Subject: Re: Referencing ceils on other page
- Date: Mon, 18 Jun 2007 20:22:59 +0100
Patrick Begou wrote:
Oliver Burnett-Hall wrote:
However it would be better to not use the address() and indirect()
worksheet functions; you can get the result that you're after like this:
This does not work. May be I wasn't very clear with my needs:
I have two arrays (one on each page) where the A columns is the key.
I need to found the same key in the two arrays to extract one cell from
the first and include it at the right place in the second.
Sorry, I hadn't read your original post carefully enough (and didn't pay
attention to where my original reply was going, it was meant to go to
The better solution would be this:
This is better as using indirect() is faster than a combination of
address() and indirect().
] [Thread Prev