Referencing ceils on other page



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]