Re: Referencing ceils on other page

[Patrick Begou <Patrick Begou hmg inpg fr>]

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:Patrick Begou hmg inpg fr |
|  BP 53 X                 | Tel 04 76 82 51 35               |
|  38041 GRENOBLE CEDEX    | Fax 04 76 82 52 71               |
===============================================================