Hi all.
Lets say I have :
Column A with 20 rows of words.
Column B with 20 rows of random numbers (1 to 20).
I want column C to have 20 rows of words that are taken from column A,
according to the index in column B.

e.g.
A B C
word1 7 word7
word2 2 word2
word3 1 word1
...
...
word20


Thank u
Moishe

C1 = INDIRECT("A"&B1)

and copy down

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"John Smith" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hi all.
> Lets say I have :
> Column A with 20 rows of words.
> Column B with 20 rows of random numbers (1 to 20).
> I want column C to have 20 rows of words that are taken from column A,
> according to the index in column B.
>
> e.g.
> A B C
> word1 7 word7
> word2 2 word2
> word3 1 word1
> ..
> ..
> word20
>
>
> Thank u
> Moishe
>
>

Another way:

=INDEX(A:A,B1)

And copy down.
--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"John Smith" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hi all.
> Lets say I have :
> Column A with 20 rows of words.
> Column B with 20 rows of random numbers (1 to 20).
> I want column C to have 20 rows of words that are taken from column A,
> according to the index in column B.
>
> e.g.
> A B C
> word1 7 word7
> word2 2 word2
> word3 1 word1
> ..
> ..
> word20
>
>
> Thank u
> Moishe
>
>