🚀 go-pugleaf

"karl gauss" wrote...
>i am using quattro pro. on page A, i have a list of names going down
>from cell A1 to cell A30. 
>
>on page B, i wish to have the name from page A cell A1 go in cell B:A1
>on page C, i wish to have the name from page A cell A2 go in cell C:A1
>on page D, i wish to have the name from page A cell A3 go in cell D:A1
>
>and so on. to achieve this, i have been doing the tedious task of
>typing +A:A1 into cell B:A1 and then typing +A:A2 into cell C:A1 and
>so on. 
>
>is there a fast way to do this?

In cell B:A1, what does the formula

@INDEX($A:$A$1..$A:$A$30,0,@CELL("Sheet",B:A2))

produce?

--
To top-post is human, to bottom-post and snip is sublime.

On Tue, 16 Mar 2004 22:35:19 GMT, Harlan Grove<hrlngrv@aol.com> wrote:

>>In cell B:A1, what does the formula
>
>@INDEX($A:$A$1..$A:$A$30,0,@CELL("Sheet",B:A2))
>
>produce?

you've cracked it! after looking up the @index and @cell functions,
and struggling with them for a little while, i think i'm on to it. 

am I right? the $A:$A$1..$A:$A$30 is to define the block from which
the names are drawn; the 0 tells what column in which a name is found,
and the @CELL("Sheet",B:A2) gives the row in which the name is found -
the @CELL("Sheet",B:A2) produces differing row values depending on
which sheet i'm on. this is the correct interpretation yes?

i must say, i'd never have been able to construct your solution
without a solid knowledge of these functions *beforehand*. i'd guess
you were a professional, and i am quite grateful for your help.

karl.