Random number selection from 4 lists

[leerem]

I have 4 lists of store numbers, each list representing the size of the
respective stores, I need to select 4 random numbers from each list of
numbers.
Each number is unique to a store and starts from 2000 up to at present 6500.
Once this store number has been generated I need it to be static so that I
can use it with lookup functions to select specific data from each store
identified. Each list starts at cell FI10:FI3000, FJ10:FJ3000, FK10:FK3000 &
FL10:FL3000 resepectively. All the numbers have been listed sequentially but
there are blank cells between the number.
Can anyone assist me with this.
Many thanks in anticipation.

Regards Lee

 

[Sean Timmons]

Start with a RANDBETWEEN(2000,6500) in your 4 columns.

Once you hit enter, highlight the 4 values, copy, paste special - values to
freeze them.

 

[leerem]

Sean, this wont work because lets say No. 2001 will be in list 1, 2002 will
be in list 3, 2004 in list 2 & 2005 in list 1 etc. selecting a random number
between 2000,6500 will include no's that may not be in the list.

 

[Sean Timmons]

Two options I can think of:

1) Continue to hit enter on the random number til it matches one of the
above, or

2) create some VB code.

Use the random generator below and loop with a find...