How do I do that...

[John Smith]

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

 

[Bob Phillips]

C1 = INDIRECT("A"&B1)

and copy down

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[RagDyer]

Another way:

=INDEX(A:A,B1)

And copy down.
--
HTH,

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