Random Cell Lookup

[john]

Hi,

I've managed to do this as follows, but i'd be interested
to see if there are better ways out there.

use the =rand() function to create a random number in the
cells next to each alphanumeric entry.
viz.
if your alphanumeric entries are in B1:B100, then in A1
enter =int(rand()*(100-1)+1)
and copy this formula down to row 100.

In your other sheet use the following formula
=vlookup(min(A1:A100),sheet1!$A$1:$B$100,2,0)

HTH,
John

 

[Freemini]

Another solution:
With your list of data held in column B of sheet2, add a row count in
column A i.e. A1=1, A2=2 etc

On sheet1 add the following formula to the cell which you want the
random data.

=VLOOKUP((RAND()*18+1),Sheet2!$A$1:$B$18,2)

This will generate a random number and read the data from the column
adjacent.

Pressing the F9 key will generate different data.

 

[Voodoodan]

Excellent guys, both work as hoped.

Thanks very much.
Dan.

 

[Guest]

Thank you!. I also tried this and it worked great