Re: Referencing ceils on other page

Oliver Burnett-Hall wrote:

I think the syntax you're looking for is:

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:

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.



|  Equipe M.O.S.T.         |          |
|  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]