I am trying to use Excel to prepare my materials (lists of sentences)
for a psychology experiment. I have one worksheet with 490 sentences,
each starting with a three-digit reference number. I have seven
'participant' worksheets, each with a randomised list of 70 reference
numbers. The total reference numbers in the participant worksheets
(490) match the total number of referenced sentences.

Now, hopefully without typing the 490 sentences all over again, I want
to get the appropriate sentence into the same cell as its
corresponding (randomised) reference number in each of the participant
worksheets. Could anybody please tell me how I might do that?

Thanks.

Kevin

Let's say Sheet1 contains the 490 items with numbers in A1:A490 and
sentences in B1:B490
In each participant sheet the random numbers are in A1:A70
In B1 of the first participant sheet enter =VLOOKUP(A1,Sheet1!$A$1:$B$490,2)
Copy this down the column - quickest way is to double click B1's fill handle
(small solid square in lower right corner of active well)
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"KevinUK" wrote in message
...
I am trying to use Excel to prepare my materials (lists of sentences)
for a psychology experiment. I have one worksheet with 490 sentences,
each starting with a three-digit reference number. I have seven
'participant' worksheets, each with a randomised list of 70 reference
numbers. The total reference numbers in the participant worksheets
(490) match the total number of referenced sentences.

Now, hopefully without typing the 490 sentences all over again, I want
to get the appropriate sentence into the same cell as its
corresponding (randomised) reference number in each of the participant
worksheets. Could anybody please tell me how I might do that?

Thanks.

Kevin