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([EMAIL PROTECTED](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:[EMAIL PROTECTED] | | BP 53 X | Tel 04 76 82 51 35 | | 38041 GRENOBLE CEDEX | Fax 04 76 82 52 71 | =============================================================== _______________________________________________ gnumeric-list mailing list [email protected] http://mail.gnome.org/mailman/listinfo/gnumeric-list
