Please help with showing cell another sheet

[bartvw]

I would like to get help on the following:

I have one sheet (sheet1) with numbered data of people (column A, sheet 1)
I have randomized them in sheet2 (=RANDBETWEEN(Sheet2!A2;Sheet2!$A$807))

In column C, sheet1 the names are standing.

My question is:

How can I get in sheet2 the numbers and names in one or two cells? Now I only get the numbers, but not the names.

I get an error when I randomize on column C, sheet 1 probably because Excel cannot randomize on texts?

Thanks for your help!!

 

[Weaver]

What are you trying to achieve?

Can you show a sample of your data?

 

[bartvw]

I am trying to randomize my data in column A, sheet1. And I am writing the formula in sheet2.

In sheet2 I get the randomized data, but only the numbers.

I would like to get the numbers shown and the names (names are in column B, sheet 1) in sheet 2.

Hope this will help