Oliver Burnett-Hall wrote:
>
> I think the syntax you're looking for is:
> =indirect("Feuil3!"&address(match(A3;Feuil3!$A$1:$A$5;0);4))
>
Thanks Oliver, it works fine.
> 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:
> =index(Feuil3!$A$1:$A$5;match(A3;Feuil3!$A$1:$A$5;0))
>
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.
Your answer solve my problem.
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
