Greetings,

Does anyone know how to make a random number pick a cell in excel?
Let me explain. I want Sheet 2 to generate two random numbers. Those
random numbers will then pick sertain cells from sheet 1. For Example
Sheet 1
B1 = 1
C1 = 2
D1 = 3
E1 = 4
F1 = 5
G1 = 6
A2 = 1
A3 = 2
A4 = 3
A5 = 4

B2 = JOHN
B3 = Joe
B4 = Sam
B5 = Ketih

Etc.

On Sheet 2
A1 = (Random number) 1
A2 = (Second Random number) 3
B1 = (Cells that reflect Cells B4 This reflects A1, A2)

Any help is welcomed.

Thanks,
Union70


--
Union70