ExcelBanter - Random Number response

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Random Number response (https://www.excelbanter.com/excel-worksheet-functions/85767-random-number-response.html)

Random Number response

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

Random Number response

Greetings,
I found out the formula. Here it is:
=OFFSET($A$1,MATCH((IF(B15<1,1,B15)),A2:A11,0),MAT CH((IF(B16<1,1,B16)),B1:K1,0)).
I would like to thank my Brother for this. He was reading this and
came up with it. Now that I got my hard question out of the way. How
do I hide this formula in my spreadsheet?

Thanks,
Union

--
Union70