Referencing ceils on other page
- From: Patrick Begou <Patrick Begou hmg inpg fr>
- To: gnumeric-list gnome org
- Subject: Referencing ceils on other page
- Date: Mon, 18 Jun 2007 12:54:38 +0200
Hi,
I'm quite new with gnumeric. I'm using the address function to obtain
the address of a cell located in an other page:
Ex: on page 'Feuil2' I search the occurence of the A2 cell in
Feuil3!A1:A5 and get the address of the cell located at this line and
the 4th column.
=address(match(A3;Feuil3!$A$1:$A$5;0);4)
This give me :
$D$3
but I would like to obtain
Feuil3!$D$3
to get the value of this field with 'indiect'
I try many solution without success:
indirect(Feuil3!address(match(A3;Feuil3!$A$1:$A$5;0);4))
indirect(Feuil3 address(match(A3;Feuil3!$A$1:$A$5;0);4))
Can someone help me ?
Thanks
Patrick
--
===============================================================
| Equipe M.O.S.T. | http://most.hmg.inpg.fr |
| Patrick BEGOU | ------------ |
| LEGI | mailto:Patrick Begou hmg inpg fr |
| BP 53 X | Tel 04 76 82 51 35 |
| 38041 GRENOBLE CEDEX | Fax 04 76 82 52 71 |
===============================================================
[
Date Prev][
Date Next] [
Thread Prev][
Thread Next]
[
Thread Index]
[
Date Index]
[
Author Index]